| 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: | 20000825100727P.t-ishii@sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
order?
--
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jackson Ching | 2000-08-25 01:32:33 | JDBC |
| Previous Message | Peter Haight | 2000-08-25 00:50:59 | Re: Large object insert performance. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodger Donaldson | 2000-08-25 03:13:34 | Regular expression query |
| Previous Message | Renato De Giovanni | 2000-08-24 22:15:35 | Re: weird structure |