Conversion of client single-byte characters is handled as follows:
Mapping is performed using ASCII, EBCDIC or active client character sets (as of the
last restart of Teradata Database) in the DBC.CharTranslationsV view.
The E2I conversion between client single-byte characters and Unicode is done as if
the characters were first converted to LATIN strings and then from LATIN to Unicode.
The E2I conversion between client single-byte characters and KANJISJIS is done as
if the characters were first converted to LATIN strings and then the TRANSLATE(string USING Latin_TO_KanjiSJIS) function were applied.
Conversion of a mixed single- and multibyte client character set is handled as follows:
The conversion of mixed single-byte/multibyte character sets is performed using hard-coded
tables, or algorithms, for the 3 supported character sets (KanjiEBCDIC, KanjiEUC,
and KanjiShift-JIS).
The DBC.CharTranslationsV view is only used for conversion of the single-byte characters
in mixed single-byte/multibyte character sets. The table is not used for KANJISJIS.