Re: Problem of capital case-insensitive letter with accent - Mailing 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
>
>