17.20 - 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
June 2022
Last Update
Content Type
User Guide
Publication ID
English (United States)

During a multinational session, Advanced SQL Engine 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.

Advanced SQL Engine 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 Vantage users.

  • A system macro named DBC.CollInstallMulti.

    This macro is invoked by a privileged user to replace the current MULTINATIONAL collation with Vantage 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 database installation procedure.