Hard-Coded and Table Conversions - 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

The following tables show when DBC.Translation, hard-coded algorithms, or other tables are used to perform conversions.

 

IF the server character set is …

THEN the DBC.Translation table defines …

LATIN

a translation between the client character set and LATIN.

All characters are accounted for using the table for conversion.

UNICODE

a translation between the client character set and UNICODE.

All characters are accounted for using the table for conversion.

KANJISJIS

the translation for single-byte characters (those characters below 0x7F, that is, the single-byte characters of KANJISJIS).

Multibyte character translation is hard-coded.

GRAPHIC

no translation. Conversion between single-byte character sets and GRAPHIC generates an error.

KANJI1

a translation between single-byte characters (those characters below 0x7F, that is, the single-byte characters of KANJISJIS) and Teradata extended JIS X 0201.

Multibyte characters are not converted.

 

IF the server character set is …

THEN the DBC.Translation table defines the translation …

LATIN

but only for the Teradata extended JIS X 0201 characters of LATIN (those characters below 0x7F).

Multibyte character translation is hard coded.

UNICODE

but only for the Teradata extended JIS X 0201 characters of UNICODE (single-byte characters below 0x7F).

Multibyte character translation is hard coded.

KANJISJIS

but only for the Teradata extended JIS X 0201part of KANJISJIS(single-byte characters below 0x7F).

Multibyte character translation is hard-coded.

GRAPHIC

but only for the Teradata extended JIS X 0201 characters of GRAPHIC.

Multibyte character translation is hard coded.

KANJI1

between single-byte characters (those characters below 0x7F, that is, the single-byte characters of KANJISJIS) and Teradata extended JIS X 0201.

Multibyte characters are not converted.

Translations between the KanjiShift-JIS client character set and server character sets are hard-coded.

 

IF the server character set is …

THEN the DBC.Translation table defines the translation …

LATIN

but only for the Teradata extended JIS X 0201 characters of LATIN (those characters below 0x7F).

Multibyte character translation is hard coded.

UNICODE

but only for the Teradata extended JIS X 0201 characters of UNICODE (single-byte characters below 0x7F).

Multibyte character translation is hard coded.

KANJISJIS

but only for the Teradata extended JIS X 0201part of KANJISJIS (single-byte characters below 0x7F).

Multibyte character translation is hard-coded.

GRAPHIC

but only for the Teradata extended JIS X 0201 characters of Graphic.

Multibyte character translation is hard coded.

KANJI1

between single-byte characters (those characters below 0x7F, that is, the single-byte characters of KANJISJIS) and Teradata extended JIS X 0201.

Multibyte characters are not converted.