| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Samuel Gendler <sgendler(at)ideasculptor(dot)com>, Eyal Wilde <eyal(at)impactsoft(dot)co(dot)il>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: a strange order by behavior |
| Date: | 2011-06-23 05:05:54 |
| Message-ID: | 1308805554.22303.0.camel@vanquo.pezone.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On tor, 2011-06-23 at 05:57 +0200, Pavel Stehule wrote:
> 2011/6/22 Peter Eisentraut <peter_e(at)gmx(dot)net>:
> > 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.
> >
>
> ok, what I can to select, when I would to use a C like default order?
createdb --locale=C --encoding=UTF8
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2011-06-23 07:18:13 | Re: a strange order by behavior |
| Previous Message | Samuel Gendler | 2011-06-23 04:34:34 | Re: a strange order by behavior |