[RESOLVED] tinyint column field value resets itself to "127", why?

[ppowell]

For some bizarre reason, each time I insert or update a row in my table image, the field value for "image_width" is fixed at 127, no matter what value I use!

Here is the schema:

CREATE TABLE /! IF NOT EXISTS / image (
id int not null auto_increment,
primary key (id),
image_path varchar(255) not null,
image_url varchar(255) not null,
image_width tinyint not null,
image_height tinyint not null,
image_alt_text varchar(255),
record_entered datetime,
unique_key varchar(20) not null
) /! TYPE=MyISAM /;

I've tried PHPMyAdmin all the way to command-line MySQL, to no avail; the image_width value constantly resets itself to "127", all other vlues are fine.

Why would this happen?

Phil

[Pieman86]

You must be inserting too large a number into the tinyint column. tinyint(4) holds values between -128 and 127 inclusive. Make it a different datatype if you need to hold bigger numbers.

[ppowell]

Sorry, I thought tinyint held a greater range as it seems to do outside of MySQL, but thanx

Phil