17.10 - Choosing a Mnemonic for an Extended Single-Byte Character Set - 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)

Choose a letter as a mnemonic for the group of character sets being defined. Use the mnemonic as the last letter in the suffix of the character set name and in the name of the mapping file. If you choose ‘x’, for example, the suffix of the character set name is _0x, and the name of the mapping file is map_0x. The system uses the letter as a link between the name of the client character set, as specified in DBC.CharTranslationsV, and the name of the mapping file.

For example, Cyrillic character sets can use the mnemonic ‘c’. If CYRILLIC_0C is the name of a client character set, the system uses the internal transitional form specified in map_0c.

If you omit the mnemonic in the name of the character set, the system does not look for a mapping file, and assumes the character set is based on standard Latin characters. A client character set named CYRILLIC does not produce Cyrillic characters, although it may appear to be working correctly due to the display characteristics of the client.

The characters ‘a’, ‘e’, ‘i’, ‘r’, ‘s’, ‘t’, and ‘u’ are reserved and cannot be used for extended single-byte character set mapping file names.