17.10 - Tools for Collation Control - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

During a multinational session, the Teradata Database checks a system table for a row containing the value MULTINATIONAL in the CollName column. The hexadecimal codes in that row determine the sort sequence for the session.

The Teradata Database provides a set of objects in database DBC with which you can manipulate, build, and maintain codes for the various collation options for Multinational users. These objects include:

  • A system table that you can access by means of the DBC.CollationsV view in which each row contains the definition of one collation sequence.

    Note that only one definition can be in effect at any given time. The default collation is based on the codes in the row where:

  • A system view named DBC.CollationsV.

    Insert site-defined collation codes through this view to populate a row in the underlying system table. The view is created with the clause GRANT SELECT TO PUBLIC to make it accessible to all Teradata Database users.

  • A system macro named DBC.CollInstallMulti.

    This macro is invoked by a privileged user to replace the current MULTINATIONAL collation with Teradata Database or site-defined codes that have been loaded into a row of the system table.

    A system restart is required before the new collation becomes the current MULTINATIONAL collation.

  • A system macro named DBC.CollAddStandard.

    This macro is run automatically when the DIP utility is executed during the Teradata Database installation procedure.