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 ,'.
>
> [image: 汉字异常.png]
> My question is that: can Trafodion store Chinese characters, if so How
> to define the ddl?
>
> Any reply is appreciated.
> Thanks,
> Qiao
>
|