Regarding inserting a unicode character into Teradata table

Database
Enthusiast

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 (1)
3 REPLIES
Enthusiast

Re: Regarding inserting a unicode character into Teradata table

What is your session characterset set to?

Enthusiast

Re: Regarding inserting a unicode character into Teradata table

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.

Enthusiast

Re: Regarding inserting a unicode character into Teradata table

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...