Strange problem with integer "127"

[lowtide]

I have a strange problem.<br>
In a table I have a field with a datatype tinyint(3).<br>
In one of my rows the number that I input is 131 but<br>
for some reason it will not allow me to change it to<br>
anything but 127! I have tried different numbers and none<br>
seem to work.<br>
Has anyone seen anything like this before.<br>
<br>
Thanks

 

[rycamor]

Yes, (its kind of deceptive with the 3 character size) a &quot;signed&quot; tinyint cannot have a range greater than -128 to 127, the &quot;unsigned&quot; tinyint has a range from 0 to 255. Suggest you change this field to smallint, which has a range of up to 65535.