* 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
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
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
---