From: prabahar <prabahar@questech.co.in>
To: Ian Barwick <barwick@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: sorting chinese characters
Date: Sat, 26 Apr 2003 07:25:48 +0530
Message-ID: <20030426015548.M3479@questech.co.in> (raw)
In-Reply-To: <200304252010.11373.barwick@gmx.net>
References: <20030425082222.M48563@questech.co.in>
<200304252010.11373.barwick@gmx.net>
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?
Thanks again,
Prabahar
> On Friday 25 April 2003 10:22, prabahar wrote:
> > Hi, I have a requirement where I have to sort a field which has euc-jp
> > characters in it. When i sort them we find that Japanese Hiragana
> > Characters are sorted properly. But Chinese characters are not sorted
> > properly.
>
> Can you define "properly"? What is it you want to sort?
>
> > Can any one give some sujestions how to fix it? I have set the
> > LC_ALL=ja_JP in the profile.
>
> Unfortunately with Japanese "Chinese" characters there is no algorithmically
> determinable sort order You will need some kind of lookup table containing
> hiragana (and possibly katakana) if you want to sort in phonetic dictionary
> order as there is a "many to many" relationship between characters /
> combinations of characters and their pronuncation(s).
>
> If the data you are dealing with represents names you don't have a chance
> unless the data comes with the pronunciation in a seperate field (which
> is why Japanese forms usually have space for both characters and
> pronuncation).
>
> It should be possible using a lookup table to determine sort order
> of a given set of characters based on their structure (radical /
> stroke count), but this method of sorting is archaic and generally
> not used.
>
> Ian Barwick
> barwick@gmx.net
_____________________________________________________________________
Any Opinions, explicit or implied, are solely those of the author and do not necessarily
represent those of Questech. This e-mail may contain confidential and/or privileged
information. If you are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any unauthorized copying,
disclosure or distribution of the material in this e-mail is strictly forbidden.
_____________________________________________________________________
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: prabahar@questech.co.in, barwick@gmx.net
Subject: Re: sorting chinese characters
In-Reply-To: <20030426015548.M3479@questech.co.in>
* 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