Re: Problem of capital case-insensitive letter with accent

lan ping 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.
>
> 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.

Are you sure you're using LATIN1 on both?

js=# \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
js | cww | UTF8
test | cww | LATIN1
[ ...snip... ]

js=# SELECT lower('ÉÈ');
lower
-------
éè
(1 row)

js=# \c test
You are now connected to database "test".
test=# SELECT lower('ÉÈ');
lower
-------
ÉÈ
(1 row)

It seems the UTF8 database performs lower() correctly, but the LATIN1
database does not.

Colin