Choosing a Mnemonic for an Extended 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™

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.