16.20 - Example: KanjiEUC Form-of-Use - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

Suppose that table_1 has three columns named cunicode, csjis, and clatin with the respective corresponding repertoires UNICODE, KANJISJIS, and LATIN. Suppose further that the current client character set is KanjiEUC.

If you submit the following statement, then the data from all columns will arrive into the application in the KanjiEUC form-of-use.

   SELECT  cunicode, csjis, clatin FROM table_1;

Because of this, the application should use variables declared as mixed single-byte character/multibyte character strings in order to store the data from the Teradata Database.