Hello
On 21/01/2008, lan ping <pinglanmtl@xxxxxxxx> 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
RegardsPavel 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>>
---------------------------(end of broadcast)---------------------------TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
