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.
Syntax
{ { CHARACTER | CHAR } [ ( n ) ] [ { CHARACTER | CHAR } SET server_character_set ] | GRAPHIC [ ( n ) ] } [ attributes [...] ]
Syntax Elements
- n
- 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.
- server_character_set
- 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:- LATIN represents fixed 8-bit characters from the ASCII ISO 8859 Latin1 or ISO 8859 Latin9 repertoires. See LATIN Server Character Set
- UNICODE represents fixed 16-bit or 32-bit characters from the Unicode® standard. See UNICODE Server Character Set.
- GRAPHIC represents fixed 16-bit UNICODE characters defined by IBM Corporation for DB2. See GRAPHIC Server Character Set.
- KANJISJIS represents mixed single byte/multibyte characters intended for Japanese applications that rely on KanjiShiftJIS characteristics. See KANJISJIS Server Character Set.
- attributes
- Appropriate data type, column storage, or column constraint attributes.