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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
