Fw: Strange UNICODE sort order - Mailing list pgsql-general

From INSYDE - lists
Subject Fw: Strange UNICODE sort order
Date
Msg-id 006501c48635$d46fc560$78d9a1c8@insyde
Whole thread Raw
Responses Re: Fw: Strange UNICODE sort order  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List 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.
 

 
 

pgsql-general by date:

Previous
From: Daniel Martini
Date:
Subject: Re: libpq: passwords WAS: scripting & psql issues
Next
From: snpe
Date:
Subject: Re: Postgresql feature