Re: BUG #2317: Wrong sorting order for (VW)

On Mon, 13 Mar 2006, TomasKlockar wrote:

>
> 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?