Microsoft KB Archive/236952

= PRB: Sort Order Has Changed with Microsoft Jet version 4.0 =

Article ID: 236952

Article Last Modified on 9/24/2003

-

APPLIES TO


 * Microsoft Data Access Components 2.5
 * Microsoft Open Database Connectivity Driver for Access 4.0
 * Microsoft OLE DB Provider for Jet 4.0
 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q236952



SYMPTOMS
Using Microsoft Jet version 4.0, sorting is different than in previous versions. For example, assume you have the following records in an Access table:

In previous versions of the Jet database engine, issuing "SELECT * FROM Table1 ORDER BY field1" gives the following results:

With Jet version 4.0, you now get the following results:



CAUSE
Microsoft Jet version 4.0 uses a new sorting order that treats hyphens (-) and single quotation marks (') as special characters. For example, Co-op and Coop are now considered equal when sorting. Also O'Connor is treated the same as OConnor.



RESOLUTION
This behavior is by design. You cannot change any settings to affect this behavior.



MORE INFORMATION
SQL Server full-text queries and Index server have similar behavior when searching.

For additional information, please see the following article in the Microsoft Knowledge Base:

200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS Queries

Additional query words: DAO 3.6 ODBC OLE DB dash mdac 2.1

Keywords: kbdatabase kbjet kbprb kbdtl KB236952

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.