Re: Sensitive sort problem?

From: "Donald Fraser" <demolish(at)cwgsy(dot)net>
To: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Sensitive sort problem?
Date: 2003-11-25 17:52:26
Message-ID: 007001c3b37c$e426a3c0$1664a8c0@DEMOLITION
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


----- Original Message -----
> "Donald Fraser" <demolish(at)cwgsy(dot)net> writes:
> > PostgreSQL 7.3.x and anything below has never had case insensitive sorting
=
> > - period.
>
> This is incorrect. In point of fact it will depend on the locale the
> database is running under. I think the OP's problem is he re-initdb'd
> without noting what locale setting was active.

Correction noted.
I over-looked the fact that a local setting can provide different collation
ordering.

Out of interest, which local settings will give a case-insensitive collation
order?

Regards
Donald Fraser

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-11-25 17:53:33 Re: Sensitive sort problem?
Previous Message William Yu 2003-11-25 17:40:23 Re: Compiling --with-openssl on Red Hat 9