17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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.