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