Re: lower('Å') or upper('å') gives imp - Mailing list pgsql-bugs

From Tom Lane
Subject Re: lower('Å') or upper('å') gives imp
Date
Msg-id 20761.1068923309@sss.pgh.pa.us
Whole thread Raw
In response to Re: lower('Å') or upper('å') gives imp  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
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


pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: lower('Å') or upper('å') gives imp
Next
From: Theodore Petrosky
Date:
Subject: Re: RC2 will not make check on OSX 10.3