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

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