Specifying the Default Server Character Set - Analytics Database - Teradata Vantage

Teradata Vantageā„¢ - Analytics Database International Character Set Support - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611
Product Category
Teradata Vantage

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)