Definitions - 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™

EUC is composed of one primary and three supplementary codesets.

The primary codeset, codeset 0, is used for ASCII characters.

The three supplementary code sets, code sets 1, 2, and 3, can be assigned to different character sets by the user.

There is a system default assignment for these codesets.

The primary code set is defined to be a single-byte with the most significant (high-order) bit set to 0. The supplementary codesets can be multiple bytes, and the most significant bit of each is set to 1.

Code sets 2 and 3 have a preceding single-shift character, known as ss 2 and ss 3, respectively, where ss 2 is 0x8E and ss 3 is 0x8F. Differentiation between codesets is as follows.

IF the most significant bit is this value … THEN …
0 the code set is one-byte ASCII.
1 the byte is checked for ss 2 or ss 3 to determine the code set. The length in bytes of characters from that code set is retrieved from an ANSI localization table governing character classification, and that number of bytes is read in.