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

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: BUG #1925: upper() and lower() fails with non-english char.
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C7A3C@algol.sollentuna.se
обсуждение исходный текст
Ответ на BUG #1925: upper() and lower() fails with non-english char.  ("Søren Vainio" <s.vainio@mail.dk>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5