16.10 - ASCII Client Character Set Support - Teradata Database

Teradata Database International Character Set Support

Teradata Database
June 2017
User Guide

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)
If you use or access any characters outside the 7-bit ASCII range, that is, characters with values from 0x80 to 0xff, use a language-specific session character set, for example, a Chinese or Korean character set, a Unicode character set (UTF8 or UTF16), or Latin1252_3A0 for all Western European Windows users.