COLLATION - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
September 2020
English (United States)
Last Update
Product Category
Teradata Vantage™

The default collation sequence for the specified user.

The maximum length of collation_sequence is 30 characters.

The COLLATION option defines the name for a collation sequence that determines the ordering of data characters during comparison operations and when sorting data in response to a SELECT query that includes an ORDER BY or WITH … BY clause.

You can override the COLLATION attribute during any session by running an appropriate SET SESSION COLLATION request. See SET SESSION COLLATION.

The collation is ASCII for configurations other than an IBM mainframe-attached host.
In this case, ASCII refers to the Teradata extension to the ASCII standard.
The collation is binary in the order of the current client character set.
Strings are compared character-by-character and padded with the pad character for the appropriate character data type where necessary.
When not CASE SPECIFIC, lowercase characters are mapped to their uppercase counterparts.
The collation is EBCDIC for an IBM mainframe-attached host.
The collation sequence used by the logon client system.
This is the default.
Japanese Industrial Standards (JIS).
The collation is as follows.
Characters and symbols from the JIS X 0201 standard (in JIS X 0201 order)
Ideographs, characters, and symbols from the JIS X 0208 standard (in JIS X 0208 order)
Ideographs, characters, and symbols from the JIS 0212 standard (in JIS X 0212 order)
IBM Kanji ideographs not present in JIS X 0208 and JIS X 0212 (in KanjiEBCDIC order)
User-defined ideographs (in U+ order)
Any remaining characters in Unicode (in U+ order)
KANJISJIS, GRAPHIC, and LATIN character types are treated as if the data were first converted to Unicode and then the appropriate JIS_COLL ordering is applied.
One of the European or Japanese language sort sequences.
The MULTINATIONAL keyword defines the name of the default collation sequence for the user to be one of the International sort orders (see SQL Data Manipulation Language).
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.