CHARACTER SET Phrase Usage Notes - Teradata Vantage

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. 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

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 Data Type Conversions.

If the CHARACTER SET phrase is applied to a character expression, the expression is first translated using the implicit translation rules and then truncated or extended as appropriate.