ASCII Client Character Set Support - Teradata Database

International Character Set Support

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata® Database

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

Description

Latin1252_3A0

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

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

Latin1252_0A

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.

Latin1_0A

International standard ISO 8859-1 (Latin 1)

Latin9_0A

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.