Hi,

Yes, Trafodion can store Chinese characters. The DDL you have used is also correct.
I think the problem is with display settings on the terminal. I am not good with those settings, so hopefully someone will be able to guide us through it.
I do see this on my terminal.

Thanks
Suresh

>>create table qiao1 (title varchar(100 bytes) character set utf8) ;

--- SQL operation complete.
>>insert into qiao1 values ('汉字异常') ;

--- 1 row(s) inserted.
>>insert into qiao1 values ('hello') ;

--- 1 row(s) inserted.
>>select * from qiao1 ;

TITLE
----------------------------------------------------------------------------------------------------

汉字异常                                                                        
hello                                                                           

--- 2 row(s) selected.
>>


On Wed, Sep 7, 2016 at 1:15 AM, 乔彦克 <qyanke@gmail.com> wrote:
Hi, all,
   I insert some lines with Chinese character into trafodion, but only get '???' where should be Chinese characters.
   Yesterday I want to load some data from Hive, this problem also emerged. 
   The field ddl contains Chinese character is 'title varchar(100 bytes)  CHARACTER SET UTF8 ,'.

汉字异常.png
    My question is that: can Trafodion store Chinese characters, if so How to define the ddl?

Any reply is appreciated.
Thanks,
Qiao