15.10 - ASCII Client Character Set Support - Teradata Database

Teradata Database International Character Set Support

Teradata Database
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 the following popular extended ASCII-based client character sets, which you must enable before using. Also see “Enabling a Client Character Set” on page 55.


ASCII Client Character Set Name



Windows Latin extension to ASCII, officially known as code page 1252.

Note: Latin1252_3A0 is 100% compatible with Windows Code Page 1252.


Windows Latin extension to ASCII, officially known as code page 1252.

Note: 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.


International standard ISO 8859-1 (Latin 1)


International standard ISO 8859-15 (Latin 9)

Note: 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.