16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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 Teradata Database 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.