CHARACTER Data Type | Data Types and Literals | Teradata Vantage - 17.10 - CHARACTER Data Type - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Represents a fixed length character string for Vantage internal character storage.

ANSI Compliance

CHARACTER is ANSI SQL:2011 compliant.

GRAPHIC is a Teradata extension to the ANSI SQL:2011 standard.


{ { CHARACTER | CHAR } [ ( n ) ]
    [ { CHARACTER | CHAR } SET server_character_set ] |

    GRAPHIC [ ( n ) ]

} [ attributes [...] ]

Syntax Elements

The number of characters or bytes allotted to the column defined with this server character set:
  • For the LATIN server character set, the maximum value for n is 64000 characters.
  • For the UNICODE and GRAPHIC server character sets, the maximum value for n is 32000 characters.
  • For the KANJISJIS server character set, the maximum value for n is 32000 bytes.

If a value for n is not specified, the default is 1.

The server character set for the character column being defined. See CHARACTER SET Phrase.

If the CHARACTER SET server_character_set clause is omitted, the default server character set depends on how the user is defined in the DEFAULT CHARACTER SET clause of the CREATE USER statement. See Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

In accordance with Teradata internationalization plans, KANJI1 support is deprecated and is to be discontinued in the near future. KANJI1 is not allowed as a default character set; the system changes the KANJI1 default character set to the UNICODE character set. Creation of new KANJI1 objects is highly restricted. Although many KANJI1 queries and applications may continue to operate, sites using KANJI1 should convert to another character set as soon as possible.
Supported values for server_character_set are as follows:
Appropriate data type, column storage, or column constraint attributes.
See Core Data Type Attributes and Storage and Constraint Attributes for specific information.