From: Ian Barwick <barwick@gmx.net>
To: prabahar <prabahar@questech.co.in>
To: pgsql-sql@postgresql.org
Subject: Re: sorting chinese characters
Date: Sat, 26 Apr 2003 08:52:29 +0200
Message-ID: <200304260852.29428.barwick@gmx.net> (raw)
In-Reply-To: <20030426015548.M3479@questech.co.in>
References: <20030425082222.M48563@questech.co.in>
<200304252010.11373.barwick@gmx.net>
<20030426015548.M3479@questech.co.in>
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
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: barwick@gmx.net, prabahar@questech.co.in
Subject: Re: sorting chinese characters
In-Reply-To: <200304260852.29428.barwick@gmx.net>
* 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