Re: Problem of capital case-insensitive letter with accent - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem of capital case-insensitive letter with accent
Date
Msg-id 18030.1200948905@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem of capital case-insensitive letter with accent  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-general
"Pavel Stehule" <pavel.stehule@gmail.com> writes:
> On 21/01/2008, Colin Wetherbee <cww@denterprises.org> wrote:
>> Pavel Stehule wrote:
>>> when database uses different encoding, than is specified in cluster's
>>> initialization, then lower, upper doesn't work.
>>
>> Oooh.  That's... confusing.

> yes, postgresql support different encodings, but this configuration is
> useless with non C locale.

FWIW, I think we've got 8.3 fixed so that it will reject combinations
of locale and encoding that don't work.  It's a bit tricky because of
the fact that locale processing isn't too well standardized :-(

            regards, tom lane

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: Problem of capital case-insensitive letter with accent
Next
From: "Merlin Moncure"
Date:
Subject: Re: US Military / Government Approval