188.8.131.52.2 Collation Rule Definition
The collation rule is used to specify collation information for character data or metadata describing character data. This is typically specified as part of the LOGIN7 message or part of a column definition in server results containing character data. For more information about column definition, see COLMETADATA.
LCID = 20BIT fIgnoreCase = BIT fIgnoreAccent = BIT fIgnoreWidth = BIT fIgnoreKana = BIT fBinary = BIT fBinary2 = BIT ColFlags = fIgnoreCase fIgnoreAccent fIgnoreKana fIgnoreWidth fBinary fBinary2 FRESERVEDBIT FRESERVEDBIT Version = 4BIT SortId = BYTE COLLATION = LCID ColFlags Version SortId
A SQL (SortId==1) collation is one of a predefined set of sort orders. It is identified by having SortId with values as described by [MSDN-SQLCollation].
For a SortId==0 collation, the LCID bits correspond to a LocaleId as defined by the National Language Support (NLS) functions. For more details, see [MS-LCID].
The sorting styles used in SQL Server are described at [MSDN-ColSortSty].
If COLLATION specifies 0x00 00 00 00 00, then it indicates request for use of raw collation.
ColFlags is represented in least significant bit order.