Re: MySQL Bug - bug list rejected

2002-06-23 Thread Roger Baklund
* Chris Beasley > 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 k

Re: MySQL Bug - bug list rejected

2002-06-23 Thread Gurhan Ozen
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

Re: MySQL Bug - bug list rejected

2002-06-23 Thread Jocelyn Fournier
Hi, Your column comid is probably declared as a tinyint which has a range between -128 and 127 (for not UNSIGNED column). If you want to allow larger values, change the column type accordingly. (Take a look here : http://www.mysql.com/doc/C/o/Column_types.html ) Regards, Jocelyn Fournier ---