Why strange sort order?
Posted by:
spamnot
Date: May 05, 2005 01:31PM
Hi
When I do
select * from table order by number asc
with table content sample
ID Number
1 1
2 2
3 3
. .
. .
10 10
11 11
12 12
13 13
. .
. .
20 20
Where number is bigint unsigned?
MySQL sorts output to be
Number
1
2
20
21
22
3
.
.
.
How can I force MySQL to sort according to "real" human readable criteria and not the unix-type ordering?
Thanks!
Subject
Written By
Posted
Why strange sort order?
May 05, 2005 01:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.