BUG #4342: upper, lower, initcap do not work with umlaute?

From: "paull" <kaeptn(dot)haddock(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4342: upper, lower, initcap do not work with umlaute?
Date: 2008-08-06 14:48:27
Message-ID: 200808061448.m76EmRjQ077915@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4342
Logged by: paull
Email address: kaeptn(dot)haddock(at)gmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message paull 2008-08-06 15:06:32 BUG #4343: upper, lower, initcap do not work with umlaute? (important!)
Previous Message Tom Lane 2008-08-06 14:39:55 Re: Hmm, nodeUnique doesn't really support backwards scan too well