From: Ian Barwick <barwick@gmx.net>
To: prabahar <prabahar@questech.co.in>
To: pgsql-sql@postgresql.org
Subject: Re: sorting chinese characters
Date: Fri, 25 Apr 2003 20:10:11 +0200
Message-ID: <200304252010.11373.barwick@gmx.net> (raw)
In-Reply-To: <20030425082222.M48563@questech.co.in>
References: <20030425082222.M48563@questech.co.in>
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
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: <200304252010.11373.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