Re: BUG #4343: upper, lower, initcap do not work with umlaute? (important!) - Mailing list pgsql-bugs

From valgog
Subject Re: BUG #4343: upper, lower, initcap do not work with umlaute? (important!)
Date
Msg-id dc983d35-a584-4fd1-8074-9697554e97c4@m45g2000hsb.googlegroups.com
Whole thread Raw
In response to BUG #4343: upper, lower, initcap do not work with umlaute? (important!)  ("paull" <kaeptn.haddock@gmail.com>)
List pgsql-bugs
On Aug 6, 5:06=A0pm, kaeptn.hadd...@gmail.com ("paull") wrote:
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A04343
> Logged by: =A0 =A0 =A0 =A0 =A0paull
> Email address: =A0 =A0 =A0kaeptn.hadd...@gmail.com
> PostgreSQL version: 8.2? not sure
> Operating system: =A0 ubuntu
> Description: =A0 =A0 =A0 =A0upper, lower, initcap do not work with umlaut=
e?
> (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('=F6=D6=F6=D6=E4=C4=E4=C4=E4'),upper(=
'=F6=D6=F6=D6=E4=AD
> =E4=C4=E4')
>
> the result is this:
> Xxx =A0 =A0 XXX =A0 =A0 =F6=D6=F6=D6=E4=C4=E4=C4=E4 =A0 =A0 =A0=F6=D6=F6=
=D6=E4=C4=E4=C4=E4
>
> 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/p=
gsql-bugs

see BUG #4319

pgsql-bugs by date:

Previous
From: valgog
Date:
Subject: Re: BUG #4342: upper, lower, initcap do not work with umlaute?
Next
From: "Blanco, Jose"
Date:
Subject: Re: Oder by not working