I have created a table as follows:
CREATE SET TABLE DUTLSB.TestUnicode ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
Ident VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
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)
Please help me understand why i get an error although i have defined the column Node as Unicode.
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...