Supported Translations Between Character Sets - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantage™

KANJI1 support is deprecated. KANJI1 is not allowed as a default character set; the system changes the KANJI1 default character set to the UNICODE character set. Creation of new KANJI1 objects is highly restricted. Although many KANJI1 queries and applications may continue to operate, sites using KANJI1 should convert to another character set as soon as possible. For more information, see KANJI1 Character Set in Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.

The following table lists the supported values that you can use for source_repertoire_name _TO_target_repertoire_name to translate between server character sets.

Value of source _TO_target Source Character Set Target Character Set
GRAPHIC_TO_KANJISJIS GRAPHIC KANJISJIS
GRAPHIC_TO_LATIN GRAPHIC LATIN
GRAPHIC_TO_UNICODE GRAPHIC UNICODE
GRAPHIC_TO_UNICODE_PadSpace GRAPHIC UNICODE
KANJI1_KanjiEBCDIC_TO_UNICODE KANJI1 UNICODE
KANJI1_KanjiEUC_TO_UNICODE KANJI1 UNICODE
KANJI1_KANJISJIS_TO_UNICODE KANJI1 UNICODE
KANJI1_SBC_TO_UNICODE KANJI1 UNICODE
KANJISJIS_TO_GRAPHIC KANJISJIS GRAPHIC
KANJISJIS_TO_LATIN KANJISJIS LATIN
KANJISJIS_TO_UNICODE KANJISJIS UNICODE
LATIN_TO_GRAPHIC LATIN GRAPHIC
LATIN_TO_KANJISJIS LATIN KANJISJIS
LATIN_TO_UNICODE LATIN UNICODE
LOCALE_TO_UNICODE KANJI1 UNICODE
LATIN
UNICODE_TO_GRAPHIC UNICODE GRAPHIC
UNICODE_TO_GRAPHIC_PadGraphic UNICODE GRAPHIC
UNICODE_TO_GRAPHIC_VarGraphic UNICODE GRAPHIC
UNICODE_TO_KANJI1_KanjiEBCDIC UNICODE KANJI1
UNICODE_TO_KANJI1_KanjiEUC UNICODE KANJI1
UNICODE_TO_KANJI1_KANJISJIS UNICODE KANJI1
UNICODE_TO_KANJI1_SBC UNICODE KANJI1
UNICODE_TO_KANJISJIS UNICODE KANJISJIS
UNICODE_TO_LATIN UNICODE LATIN
UNICODE_TO_LOCALE UNICODE KANJI1
LATIN
UNICODE_TO_UNICODE_FoldSpace UNICODE UNICODE
UNICODE_TO_UNICODE_Fullwidth UNICODE UNICODE
UNICODE_TO_UNICODE_Halfwidth UNICODE UNICODE
UNICODE_TO_UNICODE_NFC UNICODE UNICODE
UNICODE_TO_UNICODE_NFD UNICODE UNICODE
UNICODE_TO_UNICODE_NFKC UNICODE UNICODE
UNICODE_TO_UNICODE_NFKD UNICODE UNICODE

If the value specified for source_repertoire_name _TO_target_repertoire_name is UNICODE_TO_LOCALE or LOCALE_TO_UNICODE, the repertoire that the translation uses for LOCALE is determined by the language support mode for the system and the client character set for the session.

IF the language support mode is … AND the session character set is … THEN the repertoire that the translation uses for LOCALE is …
standard any LATIN
Japanese
  • ASCII
  • LATIN1252_0A
  • LATIN1_0A
  • LATIN9_0A
  • EBCDIC
  • EBCDIC037_0E
  • EBCDIC273_0E
  • EBCDIC277_0E
KANJI1_SBC
  • any other client character set with a name that has a suffix of _0A or _0E
  • a single-byte, extended site-defined client character set
  • KANJIEBCDIC5026_0I
  • KANJIEBCDIC5035_0I
  • KATAKANAEBCDIC
  • any other client character set with a name that has a suffix of _0I
KANJI1_KANJIEBCDIC
  • UTF8
  • UTF16
  • KanjiShiftJIS_0S
  • any other client character set with a name that has a suffix of _0S
  • a multibyte extended site-defined client character set
KANJI1_KANJISJIS
  • KanjiEUC_0U
  • any other client character set with a name that has a suffix of _0U
KANJI1_KanjiEUC