17.00 - Usage Notes - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

The DBC.Collations view initially contains five rows:

  • KANJI5026_STANDARD
  • KANJIKATA_STANDARD
  • KANJI5035_STANDARD
  • NORWEGIAN_STANDARD
  • SWEDISH_STANDARD

Database administrators can run the CollInstallMulti macro to specify which row in the DBC.Collations view to use as the collation sequence when the user or session COLLATION option is set to MULTINATIONAL. You must reset (initialize) the SQL Engine before the new collation sequence can take effect.

When you define a new collation with a name other than ‘MULTINATIONAL,’ set the CollInstall flag to N to avoid extra processing during startup.