Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic 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
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].

Notes <5>

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.