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

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ywb1588027283948.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.