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.