16.20 - _encoding - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

A literal for translating from KANJI1 to UNICODE that indicates a specific encoding of KANJI1.

The _encoding option is not allowed if LOCALE is specified for source_repertoire_name or target_repertoire_name.

If the translation is from these character sets:

  • KatakanaEBCDIC
  • KanjiEBCDIC5026_0I
  • KanjiEBCDIC5038_0I

use the following value for _encoding: _KanjiEBCDIC

KanjiEUC_0U, use the following value for _encoding: _KanjiEUC

KanjiShiftJIS_0S, use the following value for _encoding: _KANJISJIS

ASCII or EBCDIC, use the following value for _encoding: _SBC