SET INFORMATION COLLATE

Sets the collation used for SQL generation in information queries.

Syntax

SET INFORMATION COLLATE TO <CollationName>

Usage

Use this statement to set the collation for information queries. The specified collation will be used in place of the defined collation for table columns, index columns, and procedure/function parameters in the CreateSQL column when such objects are queried in the Information schema for a database.

For example, the Tables information table includes a CreateSQL column that indicates the SQL that is used to create the tables. By default, the collations used for the table columns will be the defined collations for the table. By using the SET INFORMATION COLLATE statement, we can change the collation used in the SQL in these columns to something other than the defined collations. This is useful for situations where one wants to reverse-engineer a database and use a different target collation.

This statement is not persistent and is reset once the current session is disconnected. To reset the collation to the defined collations again, just leave out the collation name. Also, you cannot use collation modifiers such as "CI" (case-insensitive) in this statement. The specified collation must be the root collation identifier only.

Examples

SET INFORMATION COLLATE TO "UNI"

Required Privileges

Any user can execute this statement.

SQL 2003 Standard Deviations

This statement deviates from the SQL 2003 standard in the following ways:

Deviation

Details

Extension

This SQL statement is an ElevateDB extension.

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap