Space Folding | Teradata Vantage - 17.10 - Space Folding - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

The following table shows which characters map to the SPACE character in the UNICODE server character when you translate UNICODE character strings using the TRANSLATE string function and specify UNICODE_TO_UNICODE_FoldSpace.

UNICODE Input Unicode Character Name UNICODE Fold Output Unicode Character Name
U+00A0 NO-BREAK SPACE U+0020 SPACE
U+0x00A0 OGHAM SPACE MARK U+0x0020 SPACE
U+0x180E MONGOLIAN VOWEL SEPARATOR U+0x0020 SPACE
U+2000 EN QUAD U+0020 SPACE
U+2001 EM QUAD U+0020 SPACE
U+2002 EN SPACE U+0020 SPACE
U+2003 EM SPACE U+0020 SPACE
U+2004 THREE-PER-EM SPACE U+0020 SPACE
U+2005 FOUR-PER-EM SPACE U+0020 SPACE
U+2006 SIX-PER-EM SPACE U+0020 SPACE
U+2007 FIGURE SPACE U+0020 SPACE
U+2008 PUNCTUATION SPACE U+0020 SPACE
U+2009 THIN SPACE U+0020 SPACE
U+200A HAIR SPACE U+0020 SPACE
U+202F NARROW NO-BREAK SPACE U+0020 SPACE
U+205F MEDIUM MATHEMATICAL SPACE U+0020 SPACE
U+3000 IDEOGRAPHIC SPACE U+0020 SPACE