Translations Between Fullwidth and Halfwidth Character Data - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.