moroc111
asked on
MySql 5 problem with floats
I have a stange problem with Mysql 5, i have a big table with many float fields. I can see the fields in the tables filled with information, but when i query the table i get empty sets but not for all values.
example: i can see in the table(using ems sql manager) that there are values 1.8 in a field called BGH,when i query
select * from table where BGH=1.8 i get an empty result set.
with some other values i get the correct results sets. Can anybody help?
example: i can see in the table(using ems sql manager) that there are values 1.8 in a field called BGH,when i query
select * from table where BGH=1.8 i get an empty result set.
with some other values i get the correct results sets. Can anybody help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.