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

From: tomas(at)tuxteam(dot)de (Tomas Zerolo)
To: Tomas Klockar <tomask(at)omicron(dot)se>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2317: Wrong sorting order for (VW)
Date: 2006-03-17 05:51:23
Message-ID: 20060317055123.GC11112@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Mar 16, 2006 at 11:03:59AM +0100, Tomas Klockar wrote:
[...]
> I would say that sorting V and W as the same character may work in a
> dictionary [...]

> Currently the sortingfunction in postgreSQL have disqualified itself
> from beeing used, and I do the sorting in java which treat them as
> separate caracters.
>
> This is my 5 cent,

Tomas, as it has been said, PostgreSQL uses the operating system's
locale. So you can do two things: change it (e.b. to C , which is
neutral) or fix it. If you are on an unix-like OS, man 5 locale might
help with that.

Regards
-- tomás

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim GUNDUZ 2006-03-17 06:34:13 Re: BUG #2327: Startup script for FC4 with selinux
Previous Message Tom Lane 2006-03-17 05:36:25 Re: BUG #2326: Problems Upgrading from 8.0.2