Re: Odd sort behaviour

OK, I'm waking up now. My locale is as Scott suspected, en-US.UTF-8,
and of
course my server too.

I guess I never really left "C" intellectually :) and we have a server that
thinks SQL-ASCII is cool and comparing lists of names and emails between
that server
and my local utf-8 one was rather perplexing.

I'm sure this a life-time's worth of discussion on the merits of
treating "."
as nothing when sorting....

Sorry for the noise.

Greg Stark wrote:
> On Tue, Sep 1, 2009 at 11:31 PM, Rob Sargent<robjsargent(at)gmail(dot)com> wrote:
>
>> How many ways might one accidentally do that I wonder.
>>
>
> Well most operating system distributions ask you when you install them
> what region you're in and use a collation for that region.
>
> In 8.4 you can check what collation a database is set to use with \l
> in psql. In 8.3 the entire "cluster" has a single collation which you
> can see using "show lc_collate".
>
> You can see how your system's collations work by running sort:
>
> $ LC_ALL=c sort s
> a(dot)ecke70(at)gmx(dot)de
> a(dot)fischedick(at)t-online(dot)de
> adrianohazim(at)hotmail(dot)com
> adx008(at)show(dot)org(dot)tw
> aecheniq(at)mac(dot)com
> aelefant(at)unina(dot)it
> aeo_tw(at)hotmail(dot)com
> aflores3432(at)gmail(dot)com
> afried(at)advancedneurosurgeons(dot)com
> agave007(at)comcast(dot)net
> agelsinger(at)amirsys(dot)com
> agis1doc(at)yahoo(dot)gr
>
> $ LC_ALL=en_US sort s
> adrianohazim(at)hotmail(dot)com
> adx008(at)show(dot)org(dot)tw
> aecheniq(at)mac(dot)com
> a(dot)ecke70(at)gmx(dot)de
> aelefant(at)unina(dot)it
> aeo_tw(at)hotmail(dot)com
> a(dot)fischedick(at)t-online(dot)de
> aflores3432(at)gmail(dot)com
> afried(at)advancedneurosurgeons(dot)com
> agave007(at)comcast(dot)net
> agelsinger(at)amirsys(dot)com
> agis1doc(at)yahoo(dot)gr
>
>