The following bug has been logged online: Bug reference: 3381 Logged by: Ujo Jozef Email address: [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org