Received: from double.nlr.ru (double.nlr.ru [212.193.3.3]) by hub.org (8.10.1/8.10.1) with ESMTP id e7ODiV547344; Thu, 24 Aug 2000 09:44:31 -0400 (EDT) Received: by double.nlr.ru (8.9.3/8.9.3) with ESMTP id RAA13014 Date: Thu, 24 Aug 2000 17:44:20 +0400 From: Alex Guryanow X-Mailer: The Bat! (v1.35) UNREG / CD5BF9353B3B7091 Reply-To: gav X-Priority: 3 (Normal) Message-ID: <19739.000824@nlr.ru> To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: sorting in UNICODE table Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/546 Hi, 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! Why is this happen? Regards, Alex