Re: ordering by float values

[Nick Roper]

Hi Doug,

There shouldn't be an issue with the example that you give. I just did the following:

mysql> create table floats (
-> myfloat float);
mysql> insert into floats values (2.05),(2.3),(2.4),(2);
mysql> select * from floats order by myfloat;
+---------+
| myfloat |
+---------+
| 2 |
| 2.05 |
| 2.3 |
| 2.4 |
+---------+
4 rows in set (0.00 sec)

Can you post the output from:

SHOW CREATE TABLE <yourtablename>;

and also the select statement that you are using.

Nick


--
Nick Roper