Sorting records with an apostrophe

[Hank in KC]

I've noticed that when sorting records with an apostrophe ... e.g., I'll
Walk Alone, that it appears the ' is ignored in the sorting process. Thus a
field entry I'd .... is followed by Idaho which is followed by I'll ...
which it followed by It which is followed by I've, etc.

I haven't been able to find anything on this; it appears an exception is
being made to the ASCII sort.

 

[Guest]

Access doesn't use ASCII sort anymore. It use unicode text,
and Windows/SQL Server/Microsoft sort..

I assume that MS sort uses some kind of ISO standard sort orders.

For really simple things, having a complex internationally aware
sort order is a pain in the butt. On the other hand, if you look
in a dictionary or phone book, you will see that ' is normally
ignored in real-life sorting.

(david)

 

[Jamie Collins]

Access doesn't use ASCII sort anymore. It use unicode text,
and Windows/SQL Server/Microsoft sort..

I assume that MS sort uses some kind of ISO standard sort orders.

I suspect it was more to do with Jet-SQL Server convergence rather than
standards.

See:

PRB: Sort Order Has Changed with Microsoft Jet version 4.0
http://support.microsoft.com/default.aspx?scid=kb;en-us;q236952

"Microsoft Jet version 4.0 uses a new sorting order that treats hyphens
(-) and single quotation marks (') as special characters."

Jamie.

--

 

[david epsom dot com dot au]

For Unicode data types, data comparisons are based on the Unicode code
points.

No doubt MS had some input.

(david)