Thread: lower('Å') or upper('å') gives improper results.

lower('Å') or upper('å') gives improper results.

From

"Neha Kasat"

Date:

15 November 2003, 17:13:27

Hi,

Please find the output of the simple query :

sfa_db=> select upper('å');
 upper 
-------
 å
(1 row)

PostGRESql doesn't convert the special characters like Å, Ò, etc into their lower case when using function lower and
vice-versawhen using upper. 

Neha

Re: lower('Å') or upper('å') gives imp

From

Peter Eisentraut

Date:

15 November 2003, 17:35:37

Neha Kasat writes:

> PostGRESql doesn't convert the special characters like Å, Ò, etc into
> their lower case when using function lower and vice-versa when using
> upper.

It does if you select the right locale.

--
Peter Eisentraut   peter_e@gmx.net

Re: lower('Å') or upper('å') gives imp

From

Tom Lane

Date:

15 November 2003, 18:09:07

Peter Eisentraut <peter_e@gmx.net> writes:
> Neha Kasat writes:
>> PostGRESql doesn't convert the special characters like �, �, etc into
>> their lower case when using function lower and vice-versa when using
>> upper.

> It does if you select the right locale.

... and character set.  We don't have support for this yet in multibyte
character sets (like Unicode).  You need to pick an appropriate ISOnnnn
encoding and a suitable locale setting.

            regards, tom lane