Syntax
{
{ VARCHAR | { CHARACTER | CHAR } VARYING } ( n )
[ { CHARACTER | CHAR } SET ] server_character_set |
LONG VARCHAR |
VARGRAPHIC ( n ) |
LONG VARGRAPHIC
} [ attributes [...] ]
Syntax Elements
- n
- The maximum 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.
- server_character_set
- The server character set for the character column being defined.
- 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.
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 restricted. Although KANJI1 queries and applications may continue to operate, sites using KANJI1 must convert to another character set.
- Supported values for server_character_set are as follows:
- attributes
- Appropriate data type, column storage, or column constraint attributes.
- See Core Data Type Attributes and Storage and Constraint Attributes for specific information.