LATIN Server Character Set | Data Types and Literals | Teradata Vantage - 17.10 - LATIN Server Character Set - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

Intended Use

U.S. and European applications using only those characters from ASCII, ISO 8859 Latin1, or proposed ISO 8859 Latin9 repertoires.

Pad Character

SPACE (0x20)

SQL Declaration

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

Data Type Maximum Value for n
CHARACTER(n) CHARACTER SET LATIN 64000

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

VARCHAR(n) CHARACTER SET LATIN
CLOB(n) CHARACTER SET LATIN 2097088000

Usage Notes

The semantics of the 8-bit LATIN server character set determine what characters are considered letters for the purpose of uppercasing, and how to translate between server character sets.

Database storage space for this type is allocated on a character basis.

For more information about the LATIN server character set, see Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support, B035-1125.