TRANSLATE Function Syntax | Teradata Vantage - 17.10 - TRANSLATE Function Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)
TRANSLATE (
  character_string_expression
  USING source_repertoire_name
  [ _encoding ]
  TO target_repertoire_name
  [ _suffix ]
  [ WITH ERROR ]
)

Syntax Elements

character_string_expression
A character string or character string expression for which the hexadecimal representation is to be returned.
If character_string_expression is not a character type, an error is returned.
source_repertoire_name
The source character set of the string to translate.
A value of LOCALE can be specified for source_repertoire_name to translate a character string from LATIN or KANJI1 to UNICODE using a source repertoire determined by the language support mode of the system and the client character set of the session.
_encoding
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
target_repertoire_name
The target character set of the string to translate.
A value of LOCALE can be specified for target_repertoire_name to translate a character string from UNICODE to LATIN or KANJI1 using a target repertoire determined by the language support mode of the system and the client character set of the session.
_suffix
Specifies that the translation maps some source characters to semantically different characters.
For example, a translation that specifies the _Halfwidth suffix maps any character with a halfwidth variant to that variant, and all fullwidth variants to their non-fullwidth counterparts.
The _suffix option also indicates the form of character data translated from UNICODE to the KANJI1 server character set, for example, _KanjiEUC.
Valid values are:
  • _KanjiEBCDIC
  • _KanjiEUC
  • _KANJISJIS
  • _SBC
  • _PadSpace
  • _PadGraphic
  • _Fullwidth
  • _Halfwidth
  • _FoldSpace
  • _VarGraphic
The _suffix option is not allowed if LOCALE is specified for source_repertoire_name or target_repertoire_name.
WITH ERROR
Specifies that the translation replaces offending characters in the string with a designated error character, instead of reporting an error.