Postgres Pro
Downloads
Home   >   mailing lists

Thread: lower does not handle german umlaut

lower does not handle german umlaut

From
Peter Pilsl
Date:
If I perform a select lower() on uppercased german umlauts, these wont be
converted to lowercase. Is this a bug or a feature or did I just miss
some settings ?

thnx,
peter


--
mag. peter pilsl

phone: +43 676 3574035
fax  : +43 676 3546512
email: pilsl@goldfisch.at
sms  : pilsl@max.mail.at

pgp-key available

Re: lower does not handle german umlaut

From
Tom Lane
Date:
Peter Pilsl <pilsl@goldfisch.at> writes:
> If I perform a select lower() on uppercased german umlauts, these wont be
> converted to lowercase.

AFAIK this should work if (a) the system was built with --enable-locale
and (b) you are running it in an appropriate locale setting.  The
SQL lower() function just invokes the C library's tolower() conversion
routine, so if it doesn't work your beef is with tolower() ...

            regards, tom lane

Re: lower does not handle german umlaut

From
tony
Date:
On Wed, 2001-11-07 at 18:12, Tom Lane wrote:
> Peter Pilsl <pilsl@goldfisch.at> writes:
> > If I perform a select lower() on uppercased german umlauts, these wont be
> > converted to lowercase.
>
> AFAIK this should work if (a) the system was built with --enable-locale
> and (b) you are running it in an appropriate locale setting.  The
> SQL lower() function just invokes the C library's tolower() conversion
> routine, so if it doesn't work your beef is with tolower() ...

try select to_ascii()

I use it for French

Cheers
Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html