From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Issues with LC_COLLATE, across 8.3/8.4 on various platforms |
Date: | 2010-02-02 12:26:44 |
Message-ID: | 201002021426.44936.achill@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi, i have the following problem, text ordering seems to behave incosistently across various lc_collate values, OS'es, PostgreSQL versions.
Some behaviour might be expected, some not, thats why i am asking to see where i stand with this.
Test Data
postgres(at)dynacom=# SELECT * from test_sort_order;
fooname
-------------------------
Cylinder head cover No1
Cylinder Liner No1
Cylinder head No1
(3 rows)
Now the query
# SELECT * from test_sort_order order by fooname;
in PostgreSQL 8.3.7 on x86_64-unknown-linux-gnu (lc_collate=en_US.UTF-8) gives
fooname
-------------------------
Cylinder head cover No1
Cylinder head No1
Cylinder Liner No1
while in all of
PostgreSQL 8.3.3 on i686-pc-linux-gnu (lc_collate=C)
PostgreSQL 8.3.7 (lc_collate=el_GR.UTF-8) on i386-unknown-freebsd6.3
PostgreSQL 8.4.1 on x86_64-unknown-freebsd8.0 (lc_collate=en_US.UTF-8), gives
fooname
-------------------------
Cylinder Liner No1
Cylinder head No1
Cylinder head cover No1
Database encoding is SQL_ASCII in all four cases.
--
Achilleas Mantzios
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2010-02-02 15:28:39 | Re: Issues with LC_COLLATE, across 8.3/8.4 on various platforms |
Previous Message | Devrim GÜNDÜZ | 2010-02-02 11:57:52 | Re: Using pg_migrator to upgrade 8.3->8.4 |