From: Richard Huxton <dev@archonet.com>
To: Kristian =?iso-8859-1?q?J=F6rg?= <krjg@devo.se>, pgsql-sql@postgresql.org
Subject: Re: Sort order with spaces?
Date: Wed, 17 Sep 2003 11:44:02 +0100
User-Agent: KMail/1.5
References: <3F682DB3.6080905@devo.se>
In-Reply-To: <3F682DB3.6080905@devo.se>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200309171144.02871.dev@archonet.com>

On Wednesday 17 September 2003 10:47, Kristian J=F6rg wrote:
> Hello!
>
> I am having troubles with sort order in Postgres. It seems that space is
> not handled at all?
> For instance the following rows are sorted in MS SQL Server as:
>
> LUNDGREN
> M L R
> MACDOWELL
> MUSCLE
>
> But in Postgres I get this order:
>
> LUNDGREN
> MACDOWELL
> M L R
> MUSCLE

Sort order depends upon your locale settings (specifically LC_COLLATE), whi=
ch=20
will have been set when you ran "initdb". Basically, sort orders for C ,=20
en_GB and fr will all be different. I'm guessing you expect "C" style=20
sorting.

Check the end of your postgresql.conf file to see what settings you current=
ly=20
have.
See the manuals (Localization section) and list archives for plenty of=20
details.
--=20
  Richard Huxton
  Archonet Ltd