UNICODE Halfwidth to Fullwidth | Teradata Vantage - 17.20 - UNICODE Halfwidth to Fullwidth - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
June 2022
Last Update
Content Type
User Guide
Publication ID
English (United States)

UNICODE_TO_UNICODE_Fullwidth maps the halfwidth characters of the UNICODE server character set to their fullwidth equivalents.

Vantage uses this mapping when you translate UNICODE character strings using the TRANSLATE string function and specify UNICODE_TO_UNICODE_Fullwidth.

The UNICODE_TO_UNICODE_Fullwidth mapping table is described in a text file that is available for download. See Character Set Files.

File Name Title Description
UNCDH2F.txt UNICODE to UNICODE_Fullwidth Maps the halfwidth characters of Unicode to the fullwidth characters of Unicode. Characters that are marked as HALFWIDTH are replaced with their unmarked form. Characters that are unmarked, but have a FULLWIDTH form, are mapped to that FULLWIDTH form. All other characters are unaffected.