16.20 - Translations Between Fullwidth and Halfwidth Character Data - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Functions, Expressions, and Predicates

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

UNICODE has an area known as the compatibility zone. Among other things, this zone includes halfwidth and fullwidth variants of characters that exist elsewhere in the standard.

Translations between fullwidth and halfwidth are provided by the following source_repertoire_name _TO_target_repertoire_name values.

source _TO_target Meaning
UNICODE_TO_UNICODE_Halfwidth Maps the fullwidth characters of Unicode to the halfwidth characters of Unicode. Other characters remain unchanged by the translation.

See UNICODE to UNICODE_Halfwidth, B035-1201.

UNICODE_TO_UNICODE_Fullwidth Maps the halfwidth characters of Unicode to the fullwidth characters of Unicode. At the same time, it maps any character defined by the standard as a halfwidth variant to its non-halfwidth counterpart outside the compatibility zone.

Other characters remain unchanged by the translation.

See UNICODE to UNICODE_Halfwidth, B035-1201.

UNICODE_TO_GRAPHIC_VarGraphic This translation is an ANSI equivalent to the VARGRAPHIC function.

See UNICODE to Vargraphic, B0035-1057.

The mapping and translation files are readable, but are intended to be used by software. In most cases, items not in a mapping file are mapped to themselves.

Also note that these translations are useful for maintaining more information as a step in translating GRAPHIC to LATIN and vice versa.