From: Richard Huxton <dev@archonet.com>
To: Simon Moses <ks_moses@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: order by problem
Date: Thu, 02 Dec 2004 09:03:49 +0000
Message-ID: <41AEDA75.1@archonet.com> (raw)
In-Reply-To: <20041201061449.42895.qmail@web14928.mail.yahoo.com>
References: <20041201061449.42895.qmail@web14928.mail.yahoo.com>
Simon Moses wrote:
> dear sir,
> when i run a query with order by customer_name i am
> getting the following result(ex.).
>
> AA
> A B
> AC
>
> i want it to be
>
> A B
> AA
> AB
Sorting is down to your locale (the LC_xxx configuration settings). This
is set when you initdb your database. It looks to me like you want "C"
sorting, so dump your database, re-initdb with --locale=C and restore
the dump.
There's a whole chapter on localisation in the manuals. Make sure you
are clear on the difference between encoding and locale.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, ks_moses@yahoo.com
Subject: Re: order by problem
In-Reply-To: <41AEDA75.1@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox