Skip site navigation (1) Skip section navigation (2)

Re: sorting in UNICODE table

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: gav(at)nlr(dot)ru
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: sorting in UNICODE table
Date: 2000-08-25 01:07:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-sql
> 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

Tatsuo Ishii

In response to

pgsql-sql by date

Next:From: Rodger DonaldsonDate: 2000-08-25 03:13:34
Subject: Regular expression query
Previous:From: Renato De GiovanniDate: 2000-08-24 22:15:35
Subject: Re: weird structure

pgsql-general by date

Next:From: Jackson ChingDate: 2000-08-25 01:32:33
Subject: JDBC
Previous:From: Peter HaightDate: 2000-08-25 00:50:59
Subject: Re: Large object insert performance.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group