17.10 - External Single-Byte Character Conversion - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

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.