Re: Problem of capital case-insensitive letter with accent

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
Cc: "Colin Wetherbee" <cww(at)denterprises(dot)org>, "lan ping" <pinglanmtl(at)yahoo(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: Problem of capital case-insensitive letter with accent
Date: 2008-01-21 20:55:05
Message-ID: 18030.1200948905@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> writes:
> On 21/01/2008, Colin Wetherbee <cww(at)denterprises(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2008-01-21 20:56:18 Re: US Military / Government Approval
Previous Message Tom Lane 2008-01-21 20:49:32 Re: [GENERAL] setof record "out" syntax and returning records