Hi.
Next code:

select upper(field1) from table1;

Convert all latin symbols <128 in to UPPER case but all not latin >128
in lower case locale consistent. Function lower work vicevesa upper(),
wrong too.

ilake() function work wrong too.

Environment:
ASPLinux 7.2.
gcc 2.96
kernel 2.4.9-13.smp
PostgreSQL 7.4beta3





---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Viacheslav N Tararin writes:

"Right" and "wrong" are defined by your system locale. Check what locale
you have set in your PostgreSQL server and whether the system locale works
as you expect. If you have further problems please post more detail,
including the locale configuration and some actual data.

--
Peter Eisentraut peter_e (AT) gmx (DOT) net


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend