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]
Subject: float value is changed
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