[BUGS] BUG #1685: sorting problem with LATIN2

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[BUGS] BUG #1685: sorting problem with LATIN2

Piotr Drozdowski

The following bug has been logged online:

Bug reference:      1685
Logged by:          Piotr Drozdowski
Email address:      [hidden email]
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