From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: prabahar@questech.co.in
Cc: barwick@gmx.net
Cc: pgsql-sql@postgresql.org
Subject: Re: sorting chinese characters
Date: Sun, 27 Apr 2003 09:53:30 +0900 (JST)
Message-ID: <20030427.095330.41630829.t-ishii@sra.co.jp> (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>
> 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?
There are many possible reasons why your customers are not satisfied
(it's even possible that they do not understand what "chinese"
are. Do they understand Japanese?) Anyway, can you plesae provide more
detailed info:
The OS PostgreSQL running on
PostgreSQL version
configure option
initdb option
database encoding
"chinese characters" not sorted in proper order (hex dump is
preferred)
--
Tatsuo Ishii
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: t-ishii@sra.co.jp, prabahar@questech.co.in, barwick@gmx.net
Subject: Re: sorting chinese characters
In-Reply-To: <20030427.095330.41630829.t-ishii@sra.co.jp>
* 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