Port Bug Report: sorting doesn't work

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Tomas Pluskal
Your email address : plusik(at)pohoda(dot)cz

Category : runtime: back-end
Severity : non-critical

Summary: sorting doesn't work

System Configuration
--------------------
Operating System : Linux 2.2.9

PostgreSQL version : 6.5.1

Compiler used : egcs 2.91.66

Hardware:
---------
Pentium

Versions of other tools:
------------------------

--------------------------------------------------------------------------

Problem Description:
--------------------
I have compiled postgres with --enable-locale and --with-mb=WIN
I have created a database with encoding WIN1250, my locale is set to cs_CZ (normally uses ISO-LATIN-2).
The problem is that when I create a database in encoding LATIN2, the sorting works ok, but with a database in WIN1250, it still sorts in LATIN2 (I think), so the national characters are sorted wrong.
The character translation works ok in other cases - for wxample when I run psql and set CLIENT_ENCODING to 'LATIN2', the queries for the database in WIN1250 are translated to LATIN2 and displayed OK.

--------------------------------------------------------------------------

Test Case:
----------

--------------------------------------------------------------------------

Solution:
---------
I think the backend doesn't do a character translation (when sorting) FROM the encoding of the database TO the encoding of current locale (because it sorts with the definition of characters IN current locale).
I think it should.
Thanks.

--------------------------------------------------------------------------