Specifies the server character set for a character column.
Syntax
{ CHARACTER | CHAR } SET { LATIN | UNICODE | GRAPHIC | KANJISJIS }
ANSI Compliance
The CHARACTER SET phrase is entry-level ANSI-compliant.
Implementation-defined character sets are intermediate-level ANSI-compliant.
Using CHARACTER SET to Define Internal Storage of a Column
To define the server character set for a character column, use the CHARACTER SET phrase of a character column definition in the CREATE TABLE statement.
This optional phrase defines the internal handling of character data stored on the server and has nothing to do with the client, or session, character set.
If you omit the CHARACTER SET clause, then the default server character set for the column depends on how the user accessing the data in the table is defined in the DEFAULT CHARACTER SET clause of the CREATE USER statement. For more information, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144. If there is no default character set specified for the user, the system defaults to the character set associated with the language mode, that is, LATIN for standard language mode and UNICODE for Japanese language mode.
Supported Server Character Sets for CHARACTER SET
- LATIN Server Character Set
- UNICODE Server Character Set
- GRAPHIC Server Character Set
- KANJISJIS Server Character Set
-
KANJI1 Server Character Set
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.
Restrictions
You cannot use the CHARACTER SET phrase for a UDT column.
Using the CHARACTER SET Phrase for Translation
The CHARACTER SET phrase is a form of explicit translation.
For information on explicit translation of CHARACTER data, see “TRANSLATE Function” in Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145.
If the CHARACTER SET phrase is applied to a character expression, the expression is first translated using the implicit translation rules (see “Implicit Character-to-Character Translation” in Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145), and then truncated or extended as appropriate.
FOR this server_character_set … | THE n in CHAR(n) or VARCHAR(n) indicates the number of these in the translation result … |
---|---|
|
characters |
|
bytes |