sorting in UNICODE table

From: Alex Guryanow <gav(at)nlr(dot)ru>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: sorting in UNICODE table
Date: 2000-08-24 13:44:20
Message-ID: 19739.000824@nlr.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darrin Ladd 2000-08-24 14:07:22 User security on tuple level
Previous Message jeff seaman 2000-08-24 12:55:47 Postgresql on Solaris 8

Browse pgsql-sql by date

  From Date Subject
Next Message Ingram, Bryan 2000-08-24 17:16:49 Is there a way to tell if db has changed?
Previous Message Alessandro Valenti 2000-08-24 12:52:36 Tutorial