Windows collations

Description

code page. It’s a version

collation, and is case-insensitive

(

) and accent-sensitive (

).

page. It’s a version

collation (implied by no version number

in the name), and is case-sensitive (

) and accent-sensitive (

).

Collation uses binary code point sorting rules and maps to code page. It’s a version

collation, and the Japanese Bushu Kakusu

dictionary sorting rules are ignored.

To list the Windows collations supported by your instance of SQL Server, execute the following

query.

Collation and Unicode support

ALTER TABLE (Transact-SQL)

Constants (Transact-SQL)

CREATE DATABASE

CREATE TABLE (Transact-SQL)

DECLARE @local_variable (Transact-SQL)

Table (Transact-SQL)

sys.fn_helpcollations