| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Rob Sargent <robjsargent(at)gmail(dot)com> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Odd sort behaviour |
| Date: | 2009-09-01 23:04:54 |
| Message-ID: | 407d949e0909011604t4613ac5eue8bd8fa65e72abfb@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2009-09-01 23:22:45 | Re: Odd sort behaviour |
| Previous Message | Rob Sargent | 2009-09-01 22:31:57 | Re: Odd sort behaviour |