_suffix

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

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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.