15.00 - Default Character Set - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Default Character Set

Purpose  

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.

    Related Topics

    For more information on Language Support Mode, see the System Initializer (sysinit) chapter of Support Utilities.