Re: BUG #1925: upper() and lower() fails with non-english char. - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: BUG #1925: upper() and lower() fails with non-english char.
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C7A3C@algol.sollentuna.se
Whole thread Raw
In response to BUG #1925: upper() and lower() fails with non-english char.  ("Søren Vainio" <s.vainio@mail.dk>)
List pgsql-bugs
> 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

pgsql-bugs by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5
Next
From: Tom Lane
Date:
Subject: Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5