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

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zsn1556242031050.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.