17.20 - 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
June 2022
Last Update
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 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 database to register the codes.