Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The collation rule is used to specify collation information for character data or metadata describing character data.<9> This is specified as part of the LOGIN7 (section 2.2.6.4) message or part of a column definition in server results containing character data. For more information about column definition, see COLMETADATA (section 2.2.7.4).
-
LCID = 20BIT fIgnoreCase = BIT fIgnoreAccent = BIT fIgnoreWidth = BIT fIgnoreKana = BIT fBinary = BIT fBinary2 = BIT fUTF8 = BIT ColFlags = fIgnoreCase fIgnoreAccent fIgnoreKana fIgnoreWidth fBinary fBinary2 fUTF8 FRESERVEDBIT Version = 4BIT SortId = BYTE COLLATION = LCID ColFlags Version SortId
A SQL collation is one of a predefined set of sort orders. The sort orders are identified with non-zero SortId values 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
ColFlags is represented in least significant bit order.
A COLLATION<10> value of 0x00 00 00 00 00 specifies a request for the use of raw collation.