Why int(11)

Of course, if we distinguish the sign, the value stored will be smaller. When the unsigned attribute is used, the value range is twice the original value. In fact, when we choose to use int type, whether int 3 or int 11 , it stores 4 bytes in the database. But when int 3 is used and zerofill is added, if the value you enter is 17, the system will default to the value you store as Was this article helpful?

Bikash My name is Bikash Kr. TECH, my native place in Odisha. I am a Web Programmer by profession and working on more than 50 projects to date. Posts created Leave a Reply Cancel reply Your email address will not be published. For floating types it is the total number of digits. For character fields it is the maximum number of characters that can be stored, e. The display width of the column does not affects the maximum value that can be stored in that column.

The column still will store only till the max values of INT. The number for each type of integer by default is same as the number of characters in the largest negative value of that type. This is because there is really no difference in "normal" situations, and it only makes sense to add a number to INT if the field is set to the unseigned zerofill property.

Indicates that if the number to be stored is less than N characters, the numbers will be padded with zeros on the left.