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.