17.00 - Collation Option Usage - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

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 Vantage.

Keyword Definition
ASCII HOST.

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.

CHARSET_COLL HOST.

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.

EBCDIC HOST.

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.