17.10 - Translation Tables - 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)

Translation tables map characters between an extended site-defined client character set and Unicode.

A mapping file must minimally provide translation tables that map characters from the client character set to Unicode.

A mapping file may optionally provide translation tables that map characters from Unicode to the client character set. If the optional translation tables are not defined, the system derives them by inverting the corresponding mandatory tables.

If one of the following conditions exists, however, the optional translation tables become mandatory:

  • More than one character from the client character set maps to a single Unicode character.
  • More than one Unicode character maps to a single character of the client character set.