ASCII is a character set standard in which each byte represents one character.
The Teradata translation codes for the ASCII client character set are permanently enabled in Teradata Database.
Various industrial, national, and international organizations have developed custom character sets that are extensions of the ASCII standard. If you use accented and non-Latin characters, do not use the ASCII client character set. Instead, enable use of one of the other supported ASCII-compatible client character sets or a custom (site-defined) character set that exactly matches your character set needs.
Teradata provides following popular extended ASCII-based client character sets, which you must enable before using. Also see Enabling a Client Character Set.
| ASCII Client Character Set Name | Description |
|---|---|
| Latin1252_3A0 | Windows Latin extension to ASCII, officially known as code page 1252. Latin1252_3A0 is 100% compatible with Windows Code Page 1252.
|
| Latin1252_0A | Windows Latin extension to ASCII, officially known as code page 1252. Latin1252_0A is not 100% compatible with Windows Code Page 1252. Some characters in the range of 0x80-8E and 0x90-9E in Latin1252_0A are not supported by Teradata Latin and require use of UNICODE.
|
| Latin1_0A | International standard ISO 8859-1 (Latin 1) |
| Latin9_0A | International standard ISO 8859-15 (Latin 9) |