Problem of capital case-insensitive letter with accent

From: lan ping <pinglanmtl(at)yahoo(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem of capital case-insensitive letter with accent
Date: 2008-01-21 19:11:05
Message-ID: 727465.32288.qm@web32709.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Lan


---------------------------------
Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rhys Stewart 2008-01-21 19:25:45 Re: (un)grouping question
Previous Message Raymond O'Donnell 2008-01-21 19:07:19 Re: Graphics