SESSION COLLATION

SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > SESSION COLLATION

Was this helpful?

SESSION COLLATION

The SET SESSION COLLATION collation_name sets the default collation to be used when creating tables. The session default collation name can be NONE, UCS_BASIC, UNICODE, UNICODE_CASE_INSENSITIVE, UNICODE_FRENCH, or SQL_CHARACTER. For details, see Column Specification--Define Column Characteristics.

For example:

CREATE TABLE tbl(col NVARCHAR(10) COLLATE UCS_BASIC);

can also be achieved by first changing the default SESSION collation:

SET SESSION COLLATION UCS_BASIC;

CREATE TABLE tbl(col NVARCHAR(10));

Last modified date: 11/28/2023