Float vs. Decimal

[Anon]

I was describing an earlier query problem here, where my PHP queries were not picking up floats properly from MySql :

$SQL = "SELECT MyCol FROM MyTable WHERE MyCol = 6.8";

This would not work (the result set returned nothing) until I changed the data type for this column to decimal. Has anyone ever had this problem?

I am running PHP 4.0 and the latest version of MySql (3.23) on a WinMe platform.

[Anon]

yes. in other database too. if you input 3.2, it might be 3.199999999999 in the datbase.

ues equal on float is always a problem. not just in database, in other area of programming too.

i think.