Example: KanjiEUC Form-of-Use - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ywb1588027283948.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.