Comment 2 for bug 1384360

Revision history for this message
Anoop Sharma (anoop-sharma) wrote :

cqd traf_default_col_charset has been checked in.
It could be used to set the default charset to UTF8. It could be set
in the session or inserted in system defaults table.

All char/varchar colummns in created tables will have utf8 charset.
One can explicitly set iso88591 in the create statement to override
the default value.

>>cqd traf_default_col_charset 'UTF8';

--- SQL operation complete.
>>create table c (a char(10));

--- SQL operation complete.
>>invoke c;

-- Definition of Trafodion table TRAFODION.MYTEST.C
-- Definition current Mon Nov 24 17:51:07 2014

  (
    SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , A CHAR(10 CHARS) CHARACTER SET UTF8 COLLATE
      DEFAULT DEFAULT NULL
  )

--- SQL operation complete.
>>create table c1 (a char(5) character set iso88591);

--- SQL operation complete.
>>invoke c1;

-- Definition of Trafodion table TRAFODION.MYTEST.C1
-- Definition current Mon Nov 24 17:52:55 2014

  (
    SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , A CHAR(5) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT NULL
  )

--- SQL operation complete.
>>