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

From Pavel Stehule
Subject Re: Problem of capital case-insensitive letter with accent
Date
Msg-id 162867790801211136x26169087v5206e34326448a50@mail.gmail.com
Whole thread Raw
In response to Problem of capital case-insensitive letter with accent  (lan ping <pinglanmtl@yahoo.ca>)
List pgsql-general
Hello

On 21/01/2008, lan ping <pinglanmtl@yahoo.ca> wrote:
> Hi, there
>
> In our database, some customers' names contain French accent like
>  É,é,È,è. In one server, case-insensitive search works for capital letters.
> For example,
> SELECT lower('ÉÈ') could return éè . But the other server cannot.
>

check locales. Functions lower and upper works only with correct locales.

show all;
....
lc_collate                      | cs_CZ.UTF-8
...

cs_CZ is for czech and UTF-8 for utf8 encoding

Regards
Pavel Stehule
> It is very strange, as the two server use the same Fedora linux, and
>  the same
>  version of Postgres(8.2.4). We all use LATIN1 encoding.
>
> Could you give me a hand? Thank you very much.
>
> Lan
>
>
>  ________________________________
> Be smarter than spam. See how smart SpamGuard is at giving junk email the
> boot with the All-new Yahoo! Mail
>
>

pgsql-general by date:

Previous
From: Colin Wetherbee
Date:
Subject: Re: Problem of capital case-insensitive letter with accent
Next
From: "Pavel Stehule"
Date:
Subject: Re: Problem of capital case-insensitive letter with accent