16.10 - UNICODE Server Character Set - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K

Intended Use

International applications using the Unicode repertoire or a subset thereof.

Pad Character

SPACE (U+0020)

SQL Declaration

To specify the UNICODE server character set for a character column, use the following syntax.

Data Type Maximum Value for n
CHARACTER(n) CHARACTER SET UNICODE 32000

(This is also the size of LONG VARCHAR CHARACTER SET UNICODE.)

VARCHAR(n) CHARACTER SET UNICODE
CLOB(n) CHARACTER SET UNICODE 1048544000

Usage Notes

The UNICODE server character set supports 16-bit characters from the Unicode 6.0 standard.

Each code point represents a distinct character, including non-spacing characters such as diacritical marks and joiners. All characters named as letters in UNICODE are considered as such, and are candidates for uppercasing.

Many code points in Unicode are either unassigned in Unicode 6.0 or reserved (for example surrogates). Such code points may not be stored as UNICODE character data.

Database storage space for UNICODE is allocated on a character basis.

For details about the UNICODE server character set, see International Character Set Support.