16.20 - Tools for Collation Control - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

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:

       CollName=MULTINATIONAL
       CollInstall=Y
       
  • 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.