At 09:18 PM 12/20/2002 -0500, Michael She wrote: The value's been clipped to the upper end of the range.
>>Your next question should be why that value has 9 digits to the left >>of the decimal point. :-) > > >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... Oops correction. A 10 digit value gets clipped at the upper range. So I guess the range is really n-1. Odd. sql, query, mysql, smallint -- 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
