Default integer size variation?

[Tony Emond]

Hi. I'm rather new to innoDB, although I have the old administrator certification on MySQL.

I'm working on a new project and I noticed something odd, I have no idea if it's normal or if it's a bug. Basically I've noticed that when creating or altering tables, the default integer size is different depending on whether the integer is signed or unsigned. So, if you create a column of format int, the default size is 11; however if you create a column of type int (unsigned), the default size is 10. And if you alter an integer (signed) table to become an integer (unsigned) column, the size of the column changes.

Is that the way it's supposed to work?..

I'm using the MySQL 5.1.30-community version included in WAMPserver.



Edited 1 time(s). Last edit at 02/21/2009 07:18PM by Tony Emond.