The following bug has been logged online:
Bug reference: 4343
Logged by: paull
Email address: kaeptn.haddock@gmail.com
PostgreSQL version: 8.2? not sure
Operating system: ubuntu
Description: upper, lower, initcap do not work with umlaute?
(important!)
Details:
Hello
Sorry; I forgot to mention, that the Database is encoded in SQLASCII, so I
suspect, that this is the source of the problem. Probably noone can fix it
then.
Sorry for creating unnecessary reports.
Best regards
---------------------------------------
I suspect this is no news, but then again, maybe noone ever bothered to
report?
I suspect that pgsql functions upper, lower and initcap do not support
umlaute. If I query in phppgadmin like this:
select
initcap('xxx'),upper('xxx'),initcap('öÃöÃäÃäÃä'),upper('öÃöÃäÃ
äÃä')
the result is this:
Xxx XXX öÃöÃäÃäÃä öÃöÃäÃäÃä
Hope this helps you
Best regards