Changing the Standard Multinational Default Collation | Teradata Vantage - Changing the Standard Multinational Default Collation - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ywb1588027283948.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢

After running the DIP utility, a privileged user can execute the CollInstallMulti macro to change the default sequence for multinational collation. The EXECUTE privilege on this macro is initially assigned to system users SYSADMIN and DBC.

After the change is installed, the new ordering is enforced for the session of any user whose COLLATION attribute is MULTINATIONAL, or who submits the following SQL statement:

   SET SESSION COLLATION MULTINATIONAL;