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 9999999999 (10 =
> 9s) into the table, it changed it's value to 10000000000(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.
>
> Jiang
>
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php