15.10 - Collation Option Usage - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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