From: | "Ujo Jozef" <ujojozef(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4 |
Date: | 2007-06-11 15:33:17 |
Message-ID: | 200706111533.l5BFXHaj057844@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3381
Logged by: Ujo Jozef
Email address: ujojozef(at)gmail(dot)com
PostgreSQL version: 8.2.4
Operating system: free bsd 6.2
Description: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on
8.2.4
Details:
-- SAMPLE DB, TABLE:
create database test with encoding 'UNICODE';
\c test
create table test (name varchar(8));
-- ENVIROMENT:
test=# SELECT version();
version
----------------------------------------------------------------------------
---------------------
PostgreSQL 8.2.4 on amd64-portbld-freebsd6.2, compiled by GCC cc (GCC)
3.4.6 [FreeBSD] 20060305
(1 row)
-- LOCALE SETTINGS:
test=# SHOW LC_COLLATE;
lc_collate
-------------
sk_SK.UTF-8
(1 row)
test=# SHOW LC_CTYPE;
lc_ctype
-------------
sk_SK.UTF-8
(1 row)
-- SAMPLE DATA:
insert into test values ('a');
insert into test values (''); -- lower-case "a" with acute accent
insert into test values ('z');
-- BAD SELECT RESULT:
test=# select name from test order by name;
name
------
a
z
(3 rows)
Correct order should be: a, , z. I get correct results on 8.0.8 with
exactly same data as above. Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-06-11 15:55:41 | Re: BUG #3381: Bad sort order for UTF-8 texts on sk_SK.UTF-8 locale on 8.2.4 |
Previous Message | Thomas H. | 2007-06-11 11:09:49 | Re: BUG #3378: UTF-8 upper() and lower() don't work |