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

Hello

2008/8/6 paull <kaeptn.haddock@gmail.com>:

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('öÖöÖäÃ
�äÄä')

what is your used encoding and used locale?

try

postgres=# SHOW lc_collate ;
lc_collate
-------------
cs_CZ.UTF-8
(1 row)

postgres=# SHOW server_encoding;
server_encoding
-----------------
UTF8
(1 row)

Encoding have to be same like encoding used in locales. If not, then
functions upper, lower doesn't work.

regards
Pavel Stehule

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

The following bug has been logged online:

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

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

locale of the database should be de_DE.utf8 (if the database is with
encoding UNICODE) or de_DE in case the encoding is LATIN1.

check it with

show lc_ctype
show database_encoding

You cannot officially change the locale of the database so
theoretically you can buckup and restore the database to the correctly
initialized database.

I have managed to chenge the control file and reindex the database and
do not see any problems yet.