Re: Problems with select lower() - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Problems with select lower()
Date
Msg-id 200404221532.06974.peter_e@gmx.net
Whole thread Raw
In response to Problems with select lower()  (Andreas Schmitz <a.schmitz@cityweb.de>)
List pgsql-admin
Am Donnerstag, 22. April 2004 10:55 schrieb Andreas Schmitz:
> I have a problem with select lower() using capital letters with diaeresis.
> I tried with encoding SQL_ASCII und UNICODE.

You need to set your locale to something useful (de_DE), not the encoding.
And lower() doesn't work with Unicode, but that is an independent issue.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with select lower()
Next
From: Oleg Bartunov
Date:
Subject: Re: [GENERAL] Restoring a Databases that features tserach2