Problems with select lower()

[Andreas Schmitz]

Hello *,

I have a problem with select lower() using capital letters with diaeresis. I
tried with encoding SQL_ASCII und UNICODE.


newsdb=# select lower('Ökosteuer');
lower
------------
Ökosteuer
(1 row)

newsdb=# select lower('Andreas');
lower
---------
andreas
(1 row)

Any Ideas ?

regards,

-Andreas

[Tom Lane]

Post by Andreas Schmitz
I have a problem with select lower() using capital letters with diaeresis. I
tried with encoding SQL_ASCII und UNICODE.

upper/lower currently only work with single-byte characters, so you need
to use one of the LATINn database encodings rather than UNICODE if you
want this functionality.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Peter Eisentraut]

Post by 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