Thread: Wrong uppler lower for national characters.

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

Viacheslav N Tararin writes:

> 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.

"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@gmx.net