Re: a strange order by behavior

On ons, 2011-06-22 at 02:39 -0700, Samuel Gendler wrote:
> 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 

ucs_basic is a collation name, which is an SQL object.  The argument of
createdb --lc-collate is an operating system locale name.  You can't mix
the two, even though they are similar.