On 2013-04-06, rudolf <stu3(dot)1(at)eq(dot)cz> wrote:
> Hi,
>
> I have a problem with proper collation of UTF-8 strings using PostgreSQL
> version 9.2.4 under Debian Linux 6.0 with de_DE.utf8 (but en_US behaves
> the same) locale:
>
> CREATE TABLE test_collation ( q text );
> INSERT INTO test_collation (q) VALUES ('aa'), ('ac'), ('a&b');
> SELECT * FROM test_collation ORDER BY q COLLATE "de_DE";
> q
> -----
> aa
> a&b
> ac
postgres uses the collation provided by libc (wccasecmp() I think)
> Is there a way to achieve this collation (note also the order of the
> characters with umlaut on the screenshot) with PostgreSQL? Or is it a
> glibc bug?
yeah, it's a feature of glibc.
--
⚂⚃ 100% natural