Character Conversions - Teradata Database

International Character Set Support

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata® Database

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.