[ADMIN] 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

-- 



---------------------------(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