Postgres Pro
Downloads
Home   >   mailing lists

BUG #4343: upper, lower, initcap do not work with umlaute? (important!) - Mailing list pgsql-bugs

From paull
Subject BUG #4343: upper, lower, initcap do not work with umlaute? (important!)
Date
Msg-id 200808061506.m76F6W0r088172@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

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