16.20 - _suffix - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2020-03-25
dita:mapPath
xzf1512079057909.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
kby1472250656485

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.