BUG #4342: upper, lower, initcap do not work with umlaute? - Mailing list pgsql-bugs

From paull
Subject BUG #4342: upper, lower, initcap do not work with umlaute?
Date
Msg-id 200808061448.m76EmRjQ077915@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4342: upper, lower, initcap do not work with umlaute?
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4342
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?
Details:

Hello

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

pgsql-bugs by date:

Previous
From: "Lampa"
Date:
Subject: BUG #4341: planner doesn't using index for = operation
Next
From: "Pavel Stehule"
Date:
Subject: Re: BUG #4342: upper, lower, initcap do not work with umlaute?