Wrong uppler lower for national characters.

Started by Viacheslav N Tararinover 22 years ago2 messagesbugs
Jump to latest
#1Viacheslav N Tararin
taras@dekasoft.com.ua

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

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Viacheslav N Tararin (#1)
Re: Wrong uppler lower for national characters.

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