17.10 - SET SESSION COLLATION Syntax Elements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
COLLATION
Specifies that the collation sequence in effect for the session is to be changed.
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).
collation_sequence
Name of the collation sequence to be established for the session as one of the following:
  • ASCII
  • CHARSET_COLL
  • EBCDIC
  • HOST
  • JIS_COLL
  • MULTINATIONAL
For details about collation, see Collation Option Usage and MULTINATIONAL Collation.