Обсуждение: Wrong uppler lower for national characters.

Поиск
Список
Период
Сортировка

Wrong uppler lower for national characters.

От
Viacheslav N Tararin
Дата:
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

Re: Wrong uppler lower for national characters.

От
Peter Eisentraut
Дата:
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