The following bug has been logged online:
Bug reference: 1685
Logged by: Piotr Drozdowski
Email address: piotr@ben.pl
PostgreSQL version: 8.03
Operating system: Windows 2000 Prof.
Description: sorting problem with LATIN2
Details:
If table is created with ENCODING in 'LATIN2'
I've got problem with sorting varchar(xx) fields
with "polish" letter as first char and it is only
problem with letter "¶". Rows with that letter are
always at the top rows in ascending sorting.
That situation is absent if table is crated as
WIN1250 on PostgreSQL 8.03.
I have no problem with ENCODING in LATIN2 on
Linux and PostgreSQL 7.4 too.
p.s.
sorry for my bad english