16.20 - Specifying the Default Server Character Set - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

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)