16.20 - Collation Option Usage - 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 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 using a SET SESSION COLLATION statement. See SET SESSION COLLATION.

The following table defines the collation sequences supported by Teradata Database.

Keyword Definition

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.

HOST The collation sequence used by the logon client system.

This is the default.

JIS_COLL 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)

Treatment of KANJISJIS, GRAPHIC, and LATIN character types is as if the data were first converted to Unicode and then the appropriate JIS_COLL ordering is applied.

MULTINATIONAL One of the European or Japanese language sort sequences.