On 2013-04-06, rudolf <stu3.1@xxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
