16.20 - Space Folding - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

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