16.10 - Uninstalling a Nonstandard Collation - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

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.