The default collation sequence for the specified user.
The maximum length of collation_sequence is 30 characters.
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 running an appropriate SET SESSION COLLATION request. See SET SESSION COLLATION.
- ASCII
- 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
- 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
- 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)
- KANJISJIS, GRAPHIC, and LATIN character types are treated 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.
- The MULTINATIONAL keyword defines the name of the default collation sequence for the user to be one of the International sort orders (see SQL Data Manipulation Language).
- 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.