BUG #4343: upper, lower, initcap do not work with umlaute? (important!)

On Aug 6, 5:06 pm, kaeptn.hadd...@gmail.com ("paull") wrote:

The following bug has been logged online:

Bug reference:      4343
Logged by:          paull
Email address:      kaeptn.hadd...@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

--
Sent via pgsql-bugs mailing list (pgsql-b...@postgresql.org)
To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-bugs

see BUG #4319