15.00 - Character Column Character Sets and User Default Character Sets - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Character Column Character Sets and User Default Character Sets

Character column definitions assume the character set assigned as the default for the user with CREATE USER and MODIFY USER.

You can explicitly override the default character set definitions by using the CHARACTER SET clause (see “CHARACTER SET Clause” in SQL Data Types and Literals).

For example, if the DEFAULT CHARACTER SET defined by CREATE USER is Unicode for user Hon, then whenever Hon creates or alters a table, the declaration CHARACTER(n) in CREATE/ALTER TABLE is equivalent to CHARACTER(n) CHARACTER SET UNICODE. The same is true, the necessary changes being made, for the other column data types.

If no default character set is defined for a user, then the default character set used for a new table is as follows.

 

FOR this kind of table …

The default character set when no default is defined for the user creating the table is …

system tables

Latin for non-Japanese systems.

Unicode for Japanese systems.

user tables

Latin for non-Japanese systems.

Unicode for Japanese systems.

Note that these character set definitions apply only to how the data is stored on the Teradata Database platform; they do not affect the client, or session, character set.