>>>>> "Bob" == Bob Kline <bkline@stripped> writes: Bob> On Thu,
14 Oct 1999, MySQL Server wrote: >> When using certain floating
point values in a column of type "float" >> the value displayed
differs from the actual value. For example, a >> column of type
"float(9,7)" with value of "0.283" will be displayed >> as
"0.2830000", yet the actual value is less than "0.282999999" and
>> greater than "0.28299999". One would expect the value to be
equal >> to the one displayed in the table (or at least the
value initially >> put into the table). But this is not the
case. >> Below is a short series of SQL queries to run, to
demonstrate the >> above mentioned problem. >> create table
floatTest(test1 float(9,7), test2 float(10,8)); >> insert into
floatTest values(0.283, 0.283); >> select * from floatTest; >>
select * from floatTest where test1 = 0.283; >> select * from
floatTest where test2 = 0.283; >> select * from floatTest where
test1 > 0.28299999 and test1 < 0.282999999; >> select * from
floatTest where test2 > 0.282