17.00 - MULTINATIONAL Collation - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

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.