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

Hello

2008/8/6 paull <kaeptn(dot)haddock(at)gmail(dot)com>:
>
> 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('öÖöÖäÃ
> �äÄä')
>

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

> the result is this:
> Xxx XXX öÖöÖäÄäÄä öÖöÖäÄäÄä
>
> Hope this helps you
> Best regards
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>