Working with Server Character Set Defaults - Teradata Database

International Character Set Support

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata® Database

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)