X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6FF52475A45 for ; Fri, 25 Apr 2003 04:16:57 -0400 (EDT) Received: from mail.questech.co.in (unknown [164.164.94.248]) by postgresql.org (Postfix) with ESMTP id AEC2B474E42 for ; Fri, 25 Apr 2003 04:16:49 -0400 (EDT) Received: from questech.co.in (localhost.localdomain [127.0.0.1]) by mail.questech.co.in (8.11.6/8.11.6) with ESMTP id h3P8MMc17749 for ; Fri, 25 Apr 2003 13:52:23 +0530 From: "prabahar" To: pgsql-sql@postgresql.org Subject: sorting chinese characters Date: Fri, 25 Apr 2003 13:52:22 +0530 Message-Id: <20030425082222.M48563@questech.co.in> X-Mailer: Questech WebMail 1.70 20020712 X-OriginatingIP: 61.197.246.168 (prabahar) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Spam-Status: No, hits=-5.8 required=5.0 tests=BAYES_10 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/381 X-Sequence-Number: 13082 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 any one give some sujestions how to fix it? I have set the LC_ALL=ja_JP in the profile. Thanks in advance for your replies, Prabahar _____________________________________________________________________ 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. _____________________________________________________________________