From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-ports(at)postgreSQL(dot)org |
Subject: | Port Bug Report: sorting doesn't work |
Date: | 1999-07-23 11:06:45 |
Message-ID: | 199907231106.HAA09099@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ports |
============================================================================
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.
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Uncle George | 1999-07-23 11:26:03 | Re: [PORTS] RedHat6.0 & Alpha |
Previous Message | Roger Mason | 1999-07-23 11:00:05 | Postgres regression fails completely |