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.
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 client. 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 client. |
| 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) 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. |
MULTINATIONAL Collation
The MULTINATIONAL keyword defines the name of the default collation sequence for the user to be one of the International sort orders. For more information, see International Sort Orders.
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.