You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@trafodion.apache.org by 乔彦克 <qy...@gmail.com> on 2016/09/07 06:15:50 UTC
can Trafodion store Chinese character
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
Re: can Trafodion store Chinese character
Posted by Suresh Subbiah <su...@gmail.com>.
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, 乔彦克 <qy...@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
>
Re: can Trafodion store Chinese character
Posted by Suresh Subbiah <su...@gmail.com>.
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, 乔彦克 <qy...@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
>