Character Conversions

Teradata Database International Character Set Support

brand
Software
prodname
Teradata Database
vrm_release
15.00
15.10
category
Configuration
User Guide

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.