17.20 - Setting and Changing Collations - 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

Collation can be set or changed several different ways:

  • At the user-definition level with the CREATE USER or MODIFY USER statements.
  • At the session level with the SQL SET SESSION COLLATION statement.

You can use predefined macros to change the collation default to Swedish, Norwegian, or the appropriate Japanese standard collation.

Katakana_Standard, Kanji5026_Standard, and Kanji5035_Standard are designed for the KANJI1 server character set and should not be used with other server character sets. Similarly, the other predefined collation options should not be used for KANJI1 data.

You can also define and install your own collation sequences, as explained in Defining Your Own Collation Sequence.