Search Postgresql Archives

Re: Collate problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux