17.20 - 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.20
Published
June 2022
Last Update
2022-06-24
Content Type
Configuration
User Guide
Publication ID
B035-1125-172K
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 the 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.