From: Ian Barwick <barwick@gmx.net>
To: "prabahar" <prabahar@questech.co.in>, pgsql-sql@postgresql.org
Subject: Re: sorting chinese characters
Date: Sat, 26 Apr 2003 08:52:29 +0200
User-Agent: KMail/1.5.1
References: <20030425082222.M48563@questech.co.in>
	<200304252010.11373.barwick@gmx.net>
	<20030426015548.M3479@questech.co.in>
In-Reply-To: <20030426015548.M3479@questech.co.in>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200304260852.29428.barwick@gmx.net>

On Saturday 26 April 2003 03:55, prabahar wrote:
> Thanks for your reply, Let me explain a bit more about my problem. I have a
> member master table where in i have member_name_hiragana,
> member_name_chinese [member_name_hiragana has member names in hiragana
> chars and
> member_name_chinese has member names in chinese chars].
> when i execute the query "select * from member_master orderby
> member_name_hiragana" then the sort it a proper sort order. But when i
> execute "select * from member_master orderby member_name_chinese" then it
> does not sort properly. I am not sure about the sort order, but my clients
> say that that is not a proper sort. How can i fix this?

This sounds like "member_name_hiragana" is the sort key you need so I would
stick to this unless you have some specific requirement to sort by Chinese
character, which is unusual and as I said non-trivial. It might be worth using
"member_name_chinese" as a secondary sort key to produce reproducible
results in those cases where "member_name_hiragana" are the same
but "member_name_chinese" are different; the JIS character sets contain
characters in a _crude_ order which may be useful for this case.


HTH

Ian Barwick
barwick@gmx.net