Collation SQL Server

Syntax

 :: = 
     SQL_SortRules[_Pref]_CPCodepage_

 ::=
    _CaseSensitivity_AccentSensitivity | _BIN

SortRules

A string identifying the alphabet or language whose sorting rules are applied when dictionary sorting is specified. Examples are Latin1_General or Polish.

Pref

Specifies uppercase preference.

Codepage

Specifies a one- to four-digit number that identifies the code page used by the collation. CP1 specifies code page 1252, for all other code pages the complete code page number is specified. For example, CP1251 specifies code page 1251 and CP850 specifies code page 850.

CaseSensitivity

CI specifies case-insensitive, CS specifies case-sensitive.

AccentSensitivity

AI specifies accent-insensitive, AS specifies accent-sensitive.

BIN

Specifies the binary sort order to be used.


http://msdn.microsoft.com/en-us/library/ms180175.aspx