Re: a strange order by behavior - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: a strange order by behavior
Date
Msg-id BANLkTi==wV_a5frBLPtTdGn9q1XW07HxOQ@mail.gmail.com
Whole thread Raw
In response to Re: a strange order by behavior  (Samuel Gendler <sgendler@ideasculptor.com>)
Responses Re: a strange order by behavior  (Samuel Gendler <sgendler@ideasculptor.com>)
List pgsql-sql
Hello Peter


> Pavel suggested using a collation of ucs_basic, but I get an error when I
> try that on linux:
> $ createdb -U u1 --lc-collate=ucs_basic -E UTF-8 test
> createdb: database creation failed: ERROR:  invalid locale name ucs_basic

isn't this a bug in collations?

Regards

Pavel

> I was able to create the db with --lc_collate=C and get case-sensitive
> sorting that treats spaces 'correctly,' but I have no idea how reliable that
> is with multibyte characters and it almost certainly doesn't handle accented


pgsql-sql by date:

Previous
From: Samuel Gendler
Date:
Subject: Re: a strange order by behavior
Next
From: Samuel Gendler
Date:
Subject: Re: a strange order by behavior