17.10 - Uninstalling a Nonstandard Collation - 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)

To uninstall a nonstandard collation and return to the Teradata standard MULTINATIONAL collation, perform the following procedure:

  1. Log on to a BTEQ session as system user SYSADMIN or DBC.
  2. Do one of the following:
    • Delete the row from DBC.CollationsV where CollName=’MULTINATIONAL’
    • Change to N (no) the value of the CollInstall column in the row where CollName=‘MULTINATIONAL’
  3. To reload the Teradata Standard Multinational collation, enter the following command to execute the DBC.CollAddStandard macro:
    EXECUTE DBC.CollAddStandard;
  4. Restart the Teradata Database.

You can also execute the DBC.CollAddStandard macro to reload the Teradata Standard Multinational collation if the contents of the system table become corrupted. Remember to restart the Teradata Database to register the codes.