[database,sql,query,table] Shankar Unni wrote:
> Float has accuracy problems at large ranges. A typical float has a fixed > number of so-called "significant digits". For 32-bit IEEE floats, that's > about 6. Of course, in the interests of fairness, I should note that typical doubles (64-bit IEEE) have about 15 digits of accuracy, which are generally enough, as long as you never exceed 10**13 dollars (i.e. no US govt budget work :-)). You only have to worry about precise rounding with doubles. -- Shankar (PS Of course, given the typical accuracy with which budget numbers are tossed around, one would suspect that our fine reps use floats to manipulate them..) --------------------------------------------------------------------- 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
