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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
