16.10 - Choosing a Mnemonic for an Extended Single-Byte Character Set - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

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.