Mapping File for a Single-Byte Character Set | Teradata Vantage - Mapping File for a Single-Byte Character Set - 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ā„¢

The mapping file for a new single-byte client character set, which the user creates, should contain up to four translation tables, analogous to the translation tables in DBC.CharTranslationV.

  • The first table defines the translation from the single-byte transitional form to the double-byte Unicode form.
  • The second table defines the translation from the single-byte transitional form to the corresponding uppercase double-byte Unicode form.

    Only characters that are mapped differently from the first table should be included.

  • The third table is optional, and allows for the user to create a many-to-one mapping from Unicode to the external character set if desired.

    If the third table is not present, then an inverse mapping is computed from the translation defined in the first table.

  • The fourth table defines the translation from double-byte Unicode form to the corresponding upper case single-byte internal transitional form. Only characters that are mapped differently from the optional third table (or the inverse mapping computed from the first table if the third table is not present) should be included.