Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e7P15e545255; Thu, 24 Aug 2000 21:05:40 -0400 (EDT) Received: from sranhk.sra.co.jp (sranhk [133.137.36.134]) by sraigw.sra.co.jp (8.8.7/3.7W-sraigw) with ESMTP id KAA21641; Fri, 25 Aug 2000 10:05:35 +0900 (JST) Received: from localhost (IDENT:t-ishii@srapc968-yotsuya [133.137.36.133]) by sranhk.sra.co.jp (8.9.3/3.7W-srambox) with ESMTP id KAA10546; Fri, 25 Aug 2000 10:05:34 +0900 To: gav@nlr.ru Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: sorting in UNICODE table In-Reply-To: <19739.000824@nlr.ru> References: <19739.000824@nlr.ru> X-Mailer: Mew version 1.94 on Emacs 19.34 / Mule 2.3 (SUETSUMUHANA) Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <20000825100727P.t-ishii@sra.co.jp> Date: Fri, 25 Aug 2000 10:07:27 +0900 From: Tatsuo Ishii X-Dispatcher: imput version 990905(IM130) Lines: 16 X-Archive-Number: 200008/574 > I'm use postgresql-7.0.2. It's compiled with unicode support > (./configure --enable-multibyte=UNICODE ...) > I have a table which contains both latin and non-latin letters. All they are in UTF-8 encoding. When > I try to sort the rows > > ( SELECT * FROM my_table ORDER BY sort_field ) > > I receive strange error: the rows that begin with ascii symbols are ordered while all other - are not! I guess this is because UTF-8 strings are sorted in the order of the physical representation. Can you show me sample data and its desired order? -- Tatsuo Ishii