All Forums Database
IndNaga 6 posts Joined 04/11
24 Sep 2012
Regarding inserting a unicode character into Teradata table

I have created a table as follows:
CREATE SET TABLE DUTLSB.TestUnicode ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
Ident VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Serial INTEGER,
Node VARCHAR(64) CHARACTER SET UNICODE NOT CASESPECIFIC)
 
When i try to insert a unicode character into the Node column (already defined as Charset UNICODE), as below, i still get the 'The string contains an untranslatable character error.
insert into dutlsb.TestUnicode(ident,node,serial)
values('abc','TestùęSummary',1234)
 
Please help me understand why i get an error although i have defined the column Node as Unicode.
 
Thanks.
 

Tags:
Qaisar Kiani 337 posts Joined 11/05
24 Sep 2012

What is your session characterset set to?

IndNaga 6 posts Joined 04/11
24 Sep 2012

When i did help session in sql assitant it showed me that i am using ASCII characterset. How to do i change it to UTF-8 and since i already defined the column in the table as UNICODE do i still have to set my session to unicode? ...I am new to all these.Please help me understand.

 

Qaisar Kiani 337 posts Joined 11/05
24 Sep 2012

If you are using ODBC connection, then you can change the session's charset usind ODBC Data Source Administrator. Open it and configure the DSN, there is a list of Session Character Sets available, choose UTF-8...

You must sign in to leave a comment.