<html><body><div style="color:#000; background-color:#fff; font-family:lucida console, sans-serif;font-size:10pt"><div><div><span style="font-size: 13px; ">hello all,</span></div><div><span style="font-size: 13px; ">i have a float column (f) in table t. </span></div><div><span style="font-size: 13px; ">some values do not read back as inserted.</span></div><div><span style="font-size: 13px; "><br></span></div><div><span style="font-size: 13px; ">for example:</span></div><div><span style="font-size: 13px; ">INSERT INTO t (f) values (341.1) </span><span style="font-size: 13px; ">-->> reads back as </span><span style="font-size: 13px; ">341.10001</span></div><div><font size="2">INSERT INTO t (f) values (341.2)</font><span style="font-size: 13px; ">
<span style="font-size: 13px; ">-->> </span></span><span style="font-size: 13px; ">
reads back as </span><span style="font-size: 13px; ">341.20001</span></div><div><font size="2">INSERT INTO t (f) values (341.3)</font><span style="font-size: 13px; ">
<span style="font-size: 13px; ">-->> </span></span><span style="font-size: 13px; ">
reads back as </span><span style="font-size: 13px; ">341.29999</span></div><div><font size="2">INSERT INTO t (f) values (341.4)</font><span style="font-size: 13px; ">
<span style="font-size: 13px; ">-->> </span></span><span style="font-size: 13px; ">
reads back as </span><span style="font-size: 13px; ">341.39999</span></div><div><font size="2">INSERT INTO t (f) values (341.5)</font><span style="font-size: 13px; ">
<span style="font-size: 13px; ">-->> </span></span><span style="font-size: 13px; ">
reads back as </span><span style="font-size: 13px; ">341.50000</span></div><div><font size="2">INSERT INTO t (f) values (341.6)</font><span style="font-size: 13px; ">
<span style="font-size: 13px; ">-->> </span></span><span style="font-size: 13px; ">
reads back as </span><span style="font-size: 13px; ">341.60001</span></div><div><font size="2">INSERT INTO t (f) values (341.7)</font><span style="font-size: 13px; ">
<span style="font-size: 13px; ">-->> </span></span><span style="font-size: 13px; ">
reads back as </span><span style="font-size: 13px; ">341.70001</span></div><div><font size="2">INSERT INTO t (f) values (341.8)</font><span style="font-size: 13px; ">
<span style="font-size: 13px; ">-->> </span></span><span style="font-size: 13px; ">
reads back as </span><span style="font-size: 13px; ">341.79999</span></div><div><font size="2">INSERT INTO t (f) values (341.9)</font><span style="font-size: 13px; ">
<span style="font-size: 13px; ">-->> </span></span><span style="font-size: 13px; ">
reads back as </span><span style="font-size: 13px; ">341.89999</span></div><div><font size="2">INSERT INTO t (f) values (341.10) -->> </font><span style="font-size: 13px; ">reads back as </span><span style="font-size: small; ">341.10001</span><span style="font-size: 13px; "> </span></div><div><span style="font-size: 13px; "><br></span></div><div><span style="font-size: 13px; ">the question is: is this normal?</span></div><div><span style="font-size: 13px; ">thanks,</span><br></div><div><span style="font-size: 13px;">george</span></div><div><span style="font-size: 13px;"><br></span></div><div><span style="font-size: 13px;"><br></span></div></div> </div></body></html>