Обсуждение: BUG #4342: upper, lower, initcap do not work with umlaute?

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

the result is this:
Xxx    XXX    öÖöÖäÄäÄä    öÖöÖäÄäÄä

Hope this helps you
Best regards

SGVsbG8KCjIwMDgvOC82IHBhdWxsIDxrYWVwdG4uaGFkZG9ja0BnbWFpbC5j
b20+Ogo+Cj4gVGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9u
bGluZToKPgo+IEJ1ZyByZWZlcmVuY2U6ICAgICAgNDM0Mgo+IExvZ2dlZCBi
eTogICAgICAgICAgcGF1bGwKPiBFbWFpbCBhZGRyZXNzOiAgICAgIGthZXB0
bi5oYWRkb2NrQGdtYWlsLmNvbQo+IFBvc3RncmVTUUwgdmVyc2lvbjogOC4y
PyBub3Qgc3VyZQo+IE9wZXJhdGluZyBzeXN0ZW06ICAgdWJ1bnR1Cj4gRGVz
Y3JpcHRpb246ICAgICAgICB1cHBlciwgbG93ZXIsIGluaXRjYXAgZG8gbm90
IHdvcmsgd2l0aCB1bWxhdXRlPwo+IERldGFpbHM6Cj4KPiBIZWxsbwo+Cj4g
SSBzdXNwZWN0IHRoaXMgaXMgbm8gbmV3cywgYnV0IHRoZW4gYWdhaW4sIG1h
eWJlIG5vb25lIGV2ZXIgYm90aGVyZWQgdG8KPiByZXBvcnQ/Cj4KPiBJIHN1
c3BlY3QgdGhhdCBwZ3NxbCBmdW5jdGlvbnMgdXBwZXIsIGxvd2VyIGFuZCBp
bml0Y2FwIGRvIG5vdCBzdXBwb3J0Cj4gdW1sYXV0ZS4gSWYgSSBxdWVyeSBp
biBwaHBwZ2FkbWluIGxpa2UgdGhpczoKPgo+IHNlbGVjdAo+IGluaXRjYXAo
J3h4eCcpLHVwcGVyKCd4eHgnKSxpbml0Y2FwKCfDtsOWw7bDlsOkw4TDpMOE
w6QnKSx1cHBlcignw7bDlsO2w5bDpMODCj4g77+9w6TDhMOkJykKPgoKd2hh
dCBpcyB5b3VyIHVzZWQgZW5jb2RpbmcgYW5kIHVzZWQgbG9jYWxlPwoKdHJ5
Cgpwb3N0Z3Jlcz0jIFNIT1cgbGNfY29sbGF0ZSA7CiBsY19jb2xsYXRlCi0t
LS0tLS0tLS0tLS0KIGNzX0NaLlVURi04CigxIHJvdykKCnBvc3RncmVzPSMg
U0hPVyBzZXJ2ZXJfZW5jb2Rpbmc7CiBzZXJ2ZXJfZW5jb2RpbmcKLS0tLS0t
LS0tLS0tLS0tLS0KIFVURjgKKDEgcm93KQoKRW5jb2RpbmcgaGF2ZSB0byBi
ZSBzYW1lIGxpa2UgZW5jb2RpbmcgdXNlZCBpbiBsb2NhbGVzLiBJZiBub3Qs
IHRoZW4KZnVuY3Rpb25zIHVwcGVyLCBsb3dlciBkb2Vzbid0IHdvcmsuCgpy
ZWdhcmRzClBhdmVsIFN0ZWh1bGUKCj4gdGhlIHJlc3VsdCBpcyB0aGlzOgo+
IFh4eCAgICAgWFhYICAgICDDtsOWw7bDlsOkw4TDpMOEw6QgICAgICAgw7bD
lsO2w5bDpMOEw6TDhMOkCj4KPiBIb3BlIHRoaXMgaGVscHMgeW91Cj4gQmVz
dCByZWdhcmRzCj4KPiAtLQo+IFNlbnQgdmlhIHBnc3FsLWJ1Z3MgbWFpbGlu
ZyBsaXN0IChwZ3NxbC1idWdzQHBvc3RncmVzcWwub3JnKQo+IFRvIG1ha2Ug
Y2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKPiBodHRwOi8vd3d3LnBv
c3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLWJ1Z3MKPgo=

On Aug 6, 4:48=A0pm, kaeptn.hadd...@gmail.com ("paull") wrote:
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A04342
> 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?
> 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('=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

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.