Supported Translations Between Character Sets - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-01-12
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
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 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