17.20 - Example: KanjiEUC Form-of-Use - Analytics Database - Teradata Vantage

Teradata Vantageā„¢ - Analytics Database International Character Set Support - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611

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