Thread: BUG #1925: upper() and lower() fails with non-english char.

The following bug has been logged online:

Bug reference:      1925
Logged by:          Søren Vainio
Email address:      s.vainio@mail.dk
PostgreSQL version: j2sdk1.4.2_07
Operating system:   win XP
Description:        upper() and lower() fails with non-english char.
Details:

upper(string) and lower(string) does not work on danish, swedish and german
letters like æ, ø, Ã¥, ü, and ö (æ, ø, å, ü, ö).

> The following bug has been logged online:
>=20
> Bug reference:      1925
> Logged by:          S=C3=B8ren Vainio
> Email address:      s.vainio@mail.dk
> PostgreSQL version: j2sdk1.4.2_07
> Operating system:   win XP
> Description:        upper() and lower() fails with non-english char.
> Details:=20
>=20
> upper(string) and lower(string) does not work on danish,=20
> swedish and german letters like =C3=A6, =C3=B8, =C3=A5, =C3=BC, and =C3=
=B6=20
> (æ, ø, å, ü, ö).

What encoding are you using?
This sounds a lot like what shows up when you use UNICODE (UTF8) encoding o=
n a Win32 PostgreSQL 8.0. This is not supported. It will be supported in 8.=
1, but for 8.0 you need to go with a different encoding such as LATIN1.


//Magnus