Default Character Set - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

Specifies the default character set assigned to users if a default character set is not explicitly specified in the CREATE USER statement.

Field Group

General

Valid Settings

Setting Description
1 Specifies the Latin character set as the default.
0 Specifies the Unicode character set as the default.

Default

1 on systems configured to use Standard Language Support mode.

0 on systems configured to use Japanese Language Support mode.

Upgraded systems that have not been reinitialized retain the default character set they had before being upgraded:
  • Latin for systems using Standard Language Support Mode
  • Unicode for systems using Japanese Language Support Mode

Changes Take Effect

After the DBS Control Record has been written for CREATE USER statements issued after the change. Existing users retain the default character set they had before Default Character Set was changed.