Uninstalling a Nonstandard Collation - Advanced SQL Engine - Teradata Database

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.