16.20 - MULTINATIONAL Collation - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

The MULTINATIONAL keyword defines the name of the default collation sequence for the user to be one of the International sort orders. For more information, see Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .

The MULTINATIONAL parameter determines that the International sort order is to be used. This parameter returns an error unless the hashing algorithm is set to recognize diacritical characters.

On International/European sites MULTINATIONAL collation is two-level.

On Japanese language sites, collation is single-level and is always available.