Postgres Pro
Downloads
Home   >   mailing lists

BUG #1685: sorting problem with LATIN2 - Mailing list pgsql-bugs

From Piotr Drozdowski
Subject BUG #1685: sorting problem with LATIN2
Date
Msg-id 20050527220008.E9DDAF0B00@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: shd@t2.technion.ac.il
Date:
Subject: adding users
Next
From: "fremaux"
Date:
Subject: BUG #1684: ERROR: Relation 17065 does not exist