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

On Aug 6, 5:06 pm, kaeptn(dot)hadd(dot)(dot)(dot)(at)gmail(dot)com ("paull") wrote:
> The following bug has been logged online:
>
> Bug reference:      4343
> Logged by:          paull
> Email address:      kaeptn(dot)hadd(dot)(dot)(dot)(at)gmail(dot)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(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-bugs

see BUG #4319