I don't think this is a bug, you probably choose TINYINT datatype for the column, and the maximum value a TINYINT column can have is 127, so anything over 127 will automatically be changed to 127 silently by MySQL. Choose an appropriate column datatype for your field. See: http://www.mysql.com/doc/C/o/Column_types.html Gurhan
----- Original Message ----- From: "Chris Beasley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 23, 2002 10:46 AM Subject: MySQL Bug - bug list rejected > I tried posting this on the bug list and it rejected it. > > I've got this bug in a php script of mine and I think it's because of MySQL. > I have a value I am inserting into a database and above and below my query I > can echo out the value and it is correct, but the query keeps assuming it is > "127" No matter what I do, I've renamed the variable, renamed the field, > changed my INSERT syntax a couple of times. 127, 127 ,127. MySQL is just > making up this number, there is no place it could get it. > > More detailed explanation is here: > > http://www.sitepointforums.com/showthread.php?s=&postid=477502 > > Check out the thread, if I don't have absolute proof of a MySQL bug then I > don't think such proof would be possible to get. > > Chris Beasley > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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