Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Sorting records with an apostrophe

Discussion in 'Information Technology' started by Hank in KC, Jul 28, 2006.

  1. Hank in KC

    Hank in KC
    Expand Collapse
    Guest

    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.
     
  2. Loading...


  3. Guest

    Guest
    Expand Collapse
    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)


    "Hank in KC" <hbaggs@comcast.net> wrote in message
    news:tsOdnYv1wYRJQBfZnZ2dnUVZ_oednZ2d@comcast.com...
    > 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.
    >
    >
    >
     
  4. Jamie Collins

    Jamie Collins
    Expand Collapse
    Guest

    david@epsomdotcomdotau wrote:
    > 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.

    --
     
  5. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

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

    No doubt MS had some input.

    (david)

    "Jamie Collins" <jamiecollins@xsmail.com> wrote in message
    news:1150104507.379687.89570@h76g2000cwa.googlegroups.com...
    >
    > david@epsomdotcomdotau wrote:
    >> 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.
    >
    > --
    >
     

Share This Page