15.10 - Working with Server Character Set Defaults - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Configuration
User Guide
featnum
B035-1125-015K

In addition to the global default server character set indicated by the language mode (Standard or Japanese), you can specify the default character set for specific table columns and users using SQL DDL statements.

You can specify one of the following character sets as the default. Make sure that the specified default is compatible with the client character sets with which it interacts.

  • LATIN
  • UNICODE
  • KANJISJIS
  • Note: You cannot specify GRAPHIC or KANJI1 as the default server character set.

    You can specify the default server character set:

  • For the data stored in a specific table column, using the CHARACTER SET option in a CREATE TABLE or ALTER TABLE statement.
  • For a user, using the DEFAULT CHARACTER SET options in a CREATE USER or MODIFY USER statement.
  • The default character set for data storage is determined in the following order. If a default is not defined, the system defers to the next lower item on the list:

    1 Table column default

    2 User default

    3 System default (as defined by the language mode)