Re: how to get collation according to Unicode Collation Algorithm?

On 2013-04-06, rudolf <stu3.1@eq.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