float column

George Parkinson george at microtherapy.ca
Thu Apr 19 12:52:20 CDT 2012


hello all,
i have a float column (f) in table t. 
some values do not read back as inserted.

for example:
INSERT INTO t (f) values (341.1) -->>  reads back as 341.10001
INSERT INTO t (f) values (341.2)-->> reads back as 341.20001
INSERT INTO t (f) values (341.3)-->> reads back as 341.29999
INSERT INTO t (f) values (341.4)-->> reads back as 341.39999
INSERT INTO t (f) values (341.5)-->> reads back as 341.50000
INSERT INTO t (f) values (341.6)-->> reads back as 341.60001
INSERT INTO t (f) values (341.7)-->> reads back as 341.70001
INSERT INTO t (f) values (341.8)-->> reads back as 341.79999
INSERT INTO t (f) values (341.9)-->> reads back as 341.89999
INSERT INTO t (f) values (341.10) -->> reads back as 341.10001 

the question is: is this normal?
thanks,

george
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120419/d710d171/attachment.html>


More information about the Valentina mailing list