Collate problem - Mailing list pgsql-general

From talenat
Subject Collate problem
Date
Msg-id diup78$1nuq$1@news.hub.org
Whole thread Raw
Responses Re: Collate problem  (talenat <talenat@remove.email.htnet.hr>)
List pgsql-general
Hi,
I have a mandrake 10.1 server running Postgres 8.1beta3 with hr_HR
locale. Client is a XP with WIN1250 code page.
When I use ORDER BY in query collation is out of order.
I have tried with client encoding WIN1250 and LATIN2 but with no luck.
If I use XP as a server with postgres 8.1beta3 then everything is as
expected.
The database is filled with with data from script made on XP with
WIN1250 codepage.
It looks like conversion from Latin2 to Win1250 is not correct and I
don't know what to do.
Any hint is welcome.
BR

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: searching array
Next
From: Michael Glaesemann
Date:
Subject: Re: Anybody using PostGIS?