select and max difference

[asmith]

hey guys

 

i have a table , which has only 2 rows.  a number column which is a float.

 

both rows "number" column record is  0.1 .

 

when i run this line in phpmyadmin :

select number from table

 

i get the 2 entries which is 0.1  .

 

but when i run this line :

select max(number) from table

 

i get 0.10000000149012 

 

any idea why ?  and how can i fix it ?

 

thanks a bunch

[kenchucky]

This is because floats aren't accurate.

The only solution is not to use floats.

[asmith]

hmm so what to use instead of floats to handle this type of numbers?

[aschk]

DOUBLE or NUMERIC perhaps. I've not done a lot with floats or otherwise to say which is best. Double might suffer from the same problem...

[luca200]

Double might suffer from the same problem...

I think so 

Use DECIMAL

[kenchucky]

Doubles are just bigger floats. They are still floats.