mysql returns not exact value in max function when dealing with floats?

Question

Look at this query please

SELECT max( val_amd ) FROM `best_deposits` 

I have the max value in the table equal to 14.6(the fields has type float),

But it returns 14.3599996566772

why does it happen, and how can i get the exact value?

Thanks much

Answer 1

floats are evil!

NEVER use floats for storing amounts or prices. instead of that, use an int and store the amount in cents. thats the only way to get around those problems forever.

why this happens: because floats can't be saved exactly in many cases (such as 0.6 in your case)

PS: we had those questions a hundret times for different languages till now:

• http://stackoverflow.com/q/61872/288773
• http://stackoverflow.com/q/2187197/288773
• http://stackoverflow.com/q/4008395/288773
• http://stackoverflow.com/q/3491079/288773
• http://stackoverflow.com/q/2880547/288773
• ... and a lot more

EDIT: to your comment: as i said:

use an int and store the amount in cents

(alternatively you could use an DECIMAL(10,2) (or how big/how much decimal places you need)... not sure about how this works)

Answer 2

Or you better use "decimal" with length 10,2 or something like that for storing prices.