From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: George A.J <jinujosein@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Sorting problem
Date: Tue, 14 Oct 2003 20:39:25 -0700 (PDT)
Message-ID: <20031014203640.V89503@megazone.bigpanda.com> (raw)
In-Reply-To: <20031015033054.50872.qmail@web14908.mail.yahoo.com>
References: <20031015033054.50872.qmail@web14908.mail.yahoo.com>
On Tue, 14 Oct 2003, George A.J wrote:
> hi all,
> i am using postgres 7.3.2 .i am converitng a mssql database to postgres.
> now i am facing a strange problem. sorting based on a varchar field is not working
> as expected. the non alphanumeric characters are not sorting based on the ascii
> value of them.
What OS and locale are you using? If it's not "C", you're probably
getting bit by the fact that many natural language collations (such as
en_US for example) don't consider most of the symbols except as tie
breakers when sorting. Unfortunately, to change the locale you need to
run initdb again with the appropriate locale, something like:
LANG="C" initdb -D /path/to/dataspace
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: sszabo@megazone.bigpanda.com, jinujosein@yahoo.com
Subject: Re: Sorting problem
In-Reply-To: <20031014203640.V89503@megazone.bigpanda.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