On 12/2/05, Ron Savage <[EMAIL PROTECTED]> wrote: > On Fri, 2 Dec 2005 14:30:53 -0500, Cees Hek wrote: > > inserting 10,000 will result in a row that contains 9,999.99. In > > fact inserting anything over 9,999.99 will result in 9,999.99. > > That seems to me to be a very easy mistake to make in an > > application that can have some nasty consequences. > > Exactly: This is the sickening aspect of MySQL - you can't always be sure what > it's actually doing on your behalf.
Well, I wouldn't exactly put it like that. These things are fully documented in the MySQL docs, and are not bugs, but implementation details. I bring it up more for the people that don't know MySQL works this way. I have run into lots of programmers that use MySQL all the time without knowing its idiosyncrasies. Cheers, Cees --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[email protected]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
