Postgres Pro
Downloads
Home   >   mailing lists

sorting in UNICODE table - Mailing list pgsql-general

From Alex Guryanow
Subject sorting in UNICODE table
Date
Msg-id 19739.000824@nlr.ru
Whole thread Raw
Responses Re: sorting in UNICODE table  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "jeff seaman"
Date:
Subject: Postgresql on Solaris 8
Next
From: "Ryan Williams"
Date:
Subject: Re: FW: Count & Distinct