Default Language Support Mode - Teradata Vantage - Database Engine 20

International Character Set Support

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2025-08-28
dita:mapPath
jun1747160330269.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
hqj1472245413611
lifecycle
latest
Product Category
Teradata Vantage™
Each Vantage system is configured for a language support mode as part of sysinit:

The language support mode determines the default server character set, which in turn determines which character set is used to store data.

IF you enable this language support mode … Vantage stores object names using … and the user default server character set is…
Standard UNICODE LATIN
Japanese UNICODE UNICODE

The default server character set also determines which client character sets are supported. Client Character Set Compatibility with Server Character Sets.

You can override the global default server character set associated with the language mode by specifying a default server character set for specific users or table columns.

For details about server character set options, see Server Character Sets.

Enabling the Language Support Mode

During the sysinit process, at the following prompt appears:

Enable Japanese language support?

To optimize the database for Japanese language support, answer YES. Otherwise, answer NO.

If you answer NO, Vantage uses standard language support.

Determining the Current Language Support Mode

To determine the current language support mode on your system, enter this command:

SELECT * FROM dbc.dbcinfoV WHERE infokey = 'LANGUAGE SUPPORT MODE';

For Japanese systems, the system returns:

*** Query completed. One row found. One column returned. 
   *** Total elapsed time was 1 second.
InfoData
--------------------------------------
Japanese

For Non-Japanese systems, the system returns:

*** Query completed. One row found. One column returned. 
   *** Total elapsed time was 1 second.
InfoData
--------------------------------------
Standard