Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. PRB: Sort Order Has Changed with Microsoft Jet version 4.0

PRB: Sort Order Has Changed with Microsoft Jet version 4.0

View products that this article applies to.

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:

FIELD1
W
W-
WB
W-B
In previous versions of the Jet database engine, issuing "SELECT * FROM Table1 ORDER BY field1" gives the following results:
FIELD1
W
W-
W-B
WB
With Jet version 4.0, you now get the following results:
FIELD1
W
W-
WB
W-B

↑ Back to the top

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.

↑ Back to the top

Resolution

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

↑ Back to the top

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

↑ Back to the top

Keywords: KB236952, kbprb, kbjet, kbdtl, kbdatabase

↑ Back to the top

Article Info
Article ID : 236952
Revision : 3
Created on : 9/24/2003
Published on : 9/24/2003
Exists online : False
Views : 509