Examples of SQL Collations

Installing SQL Server

Installing SQL Server

Examples of SQL Collations

These are examples of SQL collations listed on the Collation Settings screen in Microsoft® SQL Server™ 2000 Setup:

Binary order, for use with the 437 (U.S. English) character set.

This collation uses binary sort order (simple sorting based on coded value) with the U.S. English character set (code page 437 - MS-DOS Latin US).

In Transact-SQL, the string SQL_Latin1_General_Cp437_BIN is used to designate this setting.

Dictionary order, case-insensitive, accent-insensitive, for use with 1252 character set.

This collation uses the dictionary sorting rules for the U.S. English character set (code page 1252 - Windows Latin 1 ANSI, sort order ID 54). Uppercase or lowercase characters and accent marks are not considered when sorting.

In Transact-SQL, the string SQL_Latin1_General_CP1_CI_AI is used to designate this setting.

Romanian dictionary order, case-sensitive, for use with the 1250 (Central European) character set.

This collation uses the dictionary order sorting rules for the Romanian language, and uses the Central European character set (code page 1250, sort order ID 89).

In Transact-SQL, the string SQL_Romanian_Cp1250_CS_AS is used to designate this setting.

See Also

Collation Settings in Setup

Selecting a SQL Collation

Using SQL Collations

SQL Collation Name