Binary Order

Binary order is the simplest and fastest sort order. The collating sequence for this sort order is based on the numeric value (from 0 through 255) of the characters in the installed character set. Using the binary sort order, ZYXWV sorts before abcde because the character Z precedes the character a in all character sets. Sorting for extended characters (such as characters with diacritical marks) depends on the installed character set.


Important With a case-sensitive sort order, object names are case-sensitive. Because the binary sort order differentiates all character values, including uppercase and lowercase equivalents, object names are case-sensitive as well.


If you want your data to sort in a more conventional order, choose one of the dictionary sort orders. However, dictionary sort orders come with a trade-off in performance.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.