30. Data Types - Character

Data Types—Character Data

ANSI Compliant

Two ANSI data types are available for character data:

·

CHAR is for fixed-length character strings.

·

VARCHAR is for variable-length strings. (Synonyms include CHAR

VARYING and CHARACTER VARYING.) It is intermediate-level ANSI,

Teradata Extensions

In addition to the CHAR and VARCHAR (CHAR VARYING) data types,

Teradata supports LONG VARCHAR, equivalent to VARCHAR (64000), the

largest variable-length string.