On Aug 6, 4:48 pm, [EMAIL PROTECTED] ("paull") wrote:
> The following bug has been logged online:
>
> Bug reference: 4342
> Logged by: paull
> Email address: [EMAIL PROTECTED]
> 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 ([EMAIL PROTECTED])
> 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.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
