This is a discussion on Numeric Data Type limits within the MySQL Database forums, part of the Database Forums category; Hey I am trying to build a database and when I create certain fields with the Int data type, the ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hey
I am trying to build a database and when I create certain fields with the Int data type, the minimum number I can enter is a 6. Why does it not let me enter a smaller number? Also the same thing happens when I try to specify the length of an Int data type, but instead of the number being a 6, its an 11. I thought I could specify how large I wanted to the field to be... Any help is greatly appreciated. Todd |
|
|||
|
Todd Huttenstine wrote:
> Hey > > I am trying to build a database and when I create certain fields with > the Int data type, the minimum number I can enter is a 6. Why does > it not let me enter a smaller number? > > Also the same thing happens when I try to specify the length of an > Int data type, but instead of the number being a 6, its an 11. > > I thought I could specify how large I wanted to the field to be... > > Any help is greatly appreciated. > Todd the Int data type, the minimum number I can enter is a 6. Int data type, but instead of the number being a 6, its an 11 Isn't this a contradiction? |