Hello
On 21/01/2008, lan ping <[EMAIL PROTECTED]> 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
>
>
---------------------------(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
