Floats are inexact. If you want exact try the numeric data type. Its
stored as a character.
On Sat, 17 Feb 2001, Xi Jiang (ITSPORTSNET) wrote:
> Date: Sat, 17 Feb 2001 21:05:25 -0700
> From: Xi Jiang (ITSPORTSNET) <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subje
Dear all,
I have a field defined as float (16,0). When I insert 99 (10 9s) into the
table, it changed it's value to 100(1 and 10 0s). It also change some other
inserted values.
Does anybody have any idea what the reason causing it? And how can I fix that?
Thanks in advance
