From: | talenat <talenat(at)remove(dot)email(dot)htnet(dot)hr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Collate problem |
Date: | 2005-10-17 01:05:54 |
Message-ID: | diutdq$3bm$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
talenat wrote:
> 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
Here is an update to above.
If I execute SELECT * FROM atable ORDER BY afield then collate is wrong.
If I execute SELECT * FROM atable WHERE afield LIKE 'Š%' ORDER BY afield
then collate is OK for returned subset.
afield is a index field.
It seems to me that there is a bug here but I need to be sure if I am
not missing something.
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2005-10-17 02:35:27 | Re: Oracle buys Innobase |
Previous Message | Francisco Reyes | 2005-10-17 00:42:08 | Safe to kill idle connections? |