PostgreSQL Bugs - BUG #1685: sorting problem with LATIN2

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

BUG #1685: sorting problem with LATIN2

Piotr Drozdowski

2005-05-31, 11:24 am

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links