Translations Between Fullwidth and Halfwidth Character Data - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-01-12
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
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, B035-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.