Hi Peter, are you saying that FLOAT(16,3) is not a valid declaration for Mark's 'float_col', or that there's something in MySql that won't do it?? I can't find anything in Monty's MySql book (Appendix B, pg. 502) that indicates this would be an invalid declaration...
-----Original Message----- From: Peter J. Holzer [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 2:56 AM To: [EMAIL PROTECTED] Subject: Re: Float vs. double in MySQL On 2002-03-15 22:29:46 -0500, Mark Riehl wrote: > Here's what's actually in the database: > +----------------+----------------+ > | float_col | double_col | > +----------------+----------------+ > | 1007575936.000 | 1007575930.907 | > | 1007575936.000 | 1007575930.951 | > | 1007575936.000 | 1007575931.029 | > +----------------+----------------+ > > These numbers aren't too large to fit into a float - any idea what's causing > the problem? Am I missing something obvious? Yes. They are too *long* to fit into a float. A float is only good for about 6 decimal digits. The next lower float value is 1007575872. hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | "a question that if you're embarassed to | | | [EMAIL PROTECTED] | ask it, you stay stupid." __/ | http://www.hjp.at/ | -- Tim Helck on dbi-users, 2001-07-30
