How did you guess! This behaviour is why I asked the question in the first place. Why does it get clipped for a 10 digit number. Without the decimal value I believe it inserts correctly, but with the 2 decimal places it get clipped...
No, it won't insert correctly, it will still get clipped.The reason for the 9 digits is that the column requires an extra byte to store the sign for negative numbers. For positive numbers, the sign is not present, so MySQL uses it to extend the upper range.
That is what I thought initially, but the manual is not very clear:
"The decimal point and, for negative numbers, the `-' sign, are not counted in M (but space for these is reserved)"
The manual states that the negative sign and decimal points are not counted in M. By this wording, it should be 10 numeric digits.
I guess it's bad wording... or just an incorrecct entry?
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
---------------------------------------------------------------------
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
