Fw: Strange UNICODE sort order

From: "INSYDE - lists" <insyde09(at)terra(dot)com(dot)br>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Fw: Strange UNICODE sort order
Date: 2004-08-19 21:45:22
Message-ID: 006501c48635$d46fc560$78d9a1c8@insyde
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

we're doing teste with UNICODE and Postgresql 7.4.2.

After insert some data we do a select like:

select * from my_tbl_01 order by field_01

Its results is totally misdone like:

_
-
(
A
O
O_
O-
O(
OA
O A
O_A
O-A
O(A
OAA
OAAR
OAARG
OAARGU
O AR
O_AR
O-AR
O(AR
O ARG
O_ARG
O-ARG
O(ARG

Why don't Postgresql order it by clustering all the characters
that are equal, instead of sorting by the size of the string?

TIA,
Ricardo.


Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-08-19 22:01:26 Re: Fw: Strange UNICODE sort order
Previous Message Daniel Martini 2004-08-19 21:17:30 Re: libpq: passwords WAS: scripting & psql issues