From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>, "TomasKlockar" <tomask(at)omicron(dot)se> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #2317: Wrong sorting order for (VW) |
Date: | 2006-03-16 09:10:13 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCEA3513D@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
> > The following bug has been logged online:
> >
> > Bug reference: 2317
> > Logged by: TomasKlockar
> > Email address: tomask(at)omicron(dot)se
> > PostgreSQL version: 7.3.2/7.4.7
> > Operating system: linux(fedora)
> > Description: Wrong sorting order for (VW)
> > Details:
> >
> > SELECT cname FROM clients ORDER BY cname;
> >
> > sorts W before V and that is a mistake.
> >
> > the result is
> >
> > V
> > W
> > WHI
> > Vi
> > Wi
> > Volvo
> >
> > Correct order would be to place all vV before all wW.
> >
> > I think the database was initialized with UTF8 but it might
> have been
> > ISO_8859-1, however the error is easily repeatable and ill
> be happy to
> > provide a dump.
> >
> > I tested this on 7.3.2 and 7.4.7 and the error was repeatable.
>
> I think the most important thing we'd need to know is what
> locale the database was initialized with in order to try to reproduce.
>
> If you put similar data in a file and use the unix "sort"
> command with the same locale, do you get the same order?
That looks like the typical swedish locale, which sorts V and W as the
same character. Yes, that can be very annoying for some of us :-), but
that's the way it's defined.
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Klockar | 2006-03-16 10:03:59 | Re: BUG #2317: Wrong sorting order for (VW) |
Previous Message | Pavel | 2006-03-16 09:08:35 | BUG #2324: OLE DB Provider error |