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

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 (view raw or flat)
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

pgsql-general by date

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

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