trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hans Zeller <>
Subject Re: Metadata tables use UTF8 but histograms tables use UCS2
Date Thu, 14 Jan 2016 21:41:43 GMT
Hi Dave, that is for historical reasons. Initially, we supported only
ISO8859-1 column and table names, but we had a UCS2 data type. Therefore,
the column values in histograms had to be UCS2 as well. We had a project to
change all the places where we deal with ANSI names to UCS2, but that would
have been a big project.

Then, along came UTF-8, making it so much easier to deal with Unicode in
C++ programs. For Trafodion, we decided that the metadata columns for names
would change from CHAR(n) CHARACTER SET ISO88591 to CHAR(n BYTES) CHARACTER
SET UTF8. That required relatively little change in the code, both can be
represented by char * or NAString and both have the same length. The
histograms table was already in UCS2 and it was not changed. If we would
have had UTF-8 from the start we would probably have chosen that instead
for histograms.


On Thu, Jan 14, 2016 at 1:31 PM, Dave Birdsall <>

> Hi,
> I’ve noticed that Trafodion metadata tables (e.g. trafodion.”_MD_”.objects)
> commonly use UTF8 as the character set for their columns, however the
> histograms table (trafodion.<pick your schema>.sb_histograms) uses UCS2.
> I’m wondering if this was intended? Or perhaps it was an oversight from
> when the predecessor product was ported to HBase? (In the latter case, I’m
> wondering if it makes sense to open a JIRA to have them converted?)
> Dave

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message