Re: lower does not handle german umlaut - Mailing list pgsql-general

From Tom Lane
Subject Re: lower does not handle german umlaut
Date
Msg-id 5109.1005153136@sss.pgh.pa.us
Whole thread Raw
In response to lower does not handle german umlaut  (Peter Pilsl <pilsl@goldfisch.at>)
Responses Re: lower does not handle german umlaut  (tony <tony@animaproductions.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: functions, shell script
Next
From: Tom Lane
Date:
Subject: Re: Performance Question Followup No.2