16.20 - Choosing a Mnemonic for an Extended Single-Byte Character Set - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine International Character Set Support

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
User Guide

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.