Re: [SQL] a strange order by behavior

2011-06-22 Thread Peter Eisentraut
On tor, 2011-06-23 at 05:57 +0200, Pavel Stehule wrote: > 2011/6/22 Peter Eisentraut : > > 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

Re: [SQL] a strange order by behavior

2011-06-22 Thread Samuel Gendler
On Wed, Jun 22, 2011 at 8:57 PM, Pavel Stehule wrote: > 2011/6/22 Peter Eisentraut : > > 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_

Re: [SQL] a strange order by behavior

2011-06-22 Thread Pavel Stehule
2011/6/22 Peter Eisentraut : > 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:  in

Re: [SQL] a strange order by behavior

2011-06-22 Thread Peter Eisentraut
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_ba

Re: [SQL] a strange order by behavior

2011-06-22 Thread Peter Eisentraut
On ons, 2011-06-22 at 01:43 -0700, Samuel Gendler wrote: > I seem to recall a thread here about it ignoring spaces entirely in that > collation (and maybe ignoring capitalization, too?). The way it works is that every collating element (letter or other character or character group that you sort as

Re: [SQL] a strange order by behavior

2011-06-22 Thread Tom Lane
Samuel Gendler writes: > Interesting. The original thread to which I was referring has a subject of > "Sorting Issue" and the original request showed a list of vehicle model > names which were sorting as though there were no spaces. The user had > collation set to en_US.UTF-8. However, my databa

Re: [SQL] a strange order by behavior

2011-06-22 Thread Pavel Stehule
> I'm actually surprised that european users aren't complaining about this all > the time, but maybe european users are used to seeing things ordered in a > manner which doesn't honour the 'correct' ordering of accented characters. >  Actually, I wonder if the probable explanation of the lack of co

Re: [SQL] a strange order by behavior

2011-06-22 Thread Samuel Gendler
On Wed, Jun 22, 2011 at 3:39 AM, Samuel Gendler wrote: > > > On Wed, Jun 22, 2011 at 3:01 AM, Pavel Stehule wrote: > >> 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

Re: [SQL] a strange order by behavior

2011-06-22 Thread Samuel Gendler
On Wed, Jun 22, 2011 at 3:01 AM, Pavel Stehule wrote: > 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

Re: [SQL] a strange order by behavior

2011-06-22 Thread Samuel Gendler
On Wed, Jun 22, 2011 at 2:39 AM, Samuel Gendler wrote: > > 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 > characte

Re: [SQL] a strange order by behavior

2011-06-22 Thread Pavel Stehule
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 wa

Re: [SQL] a strange order by behavior

2011-06-22 Thread Samuel Gendler
Interesting. The original thread to which I was referring has a subject of "Sorting Issue" and the original request showed a list of vehicle model names which were sorting as though there were no spaces. The user had collation set to en_US.UTF-8. However, my database (on OS X) sorts both his exam

Re: [SQL] a strange order by behavior

2011-06-22 Thread Pavel Stehule
Hello a equalent of C collate for UTF8 is ucs_basic Regards Pavel Stehule 2011/6/22 Samuel Gendler : > > > On Tue, Jun 21, 2011 at 3:37 AM, Eyal Wilde wrote: >> >> the database collation is: en_US.UTF-8 >> drop table t1; >> create table t1 (recid int ,f1 varchar(20)); >> insert into t1 values

Re: [SQL] a strange order by behavior

2011-06-22 Thread Samuel Gendler
On Tue, Jun 21, 2011 at 3:37 AM, Eyal Wilde wrote: > the database collation is: en_US.UTF-8 > > drop table t1; > create table t1 (recid int ,f1 varchar(20)); > insert into t1 values (1,'a'); > insert into t1 values (2,' '); > insert into t1 values (3,'aa'); > insert into t1 values (4,' a'); > sel