Mr Nick Posted August 18, 2010 Share Posted August 18, 2010 I'm confused by the entire thing. If I'm only storing a maxlength of 3 digits, would it be recommended to use tinyint? Is there limits? What's the differences and advantages? Thank you. Link to comment https://forums.phpfreaks.com/topic/211039-big-int-int-medium-int-small-int-and-tiny-int/ Share on other sites More sharing options...
Adam Posted August 18, 2010 Share Posted August 18, 2010 If you want to store 3 digits (assuming up to 999) you'd need to use a smallint, as the max. value for an unsigned tinyint is 255. The manual explains it all: http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html Link to comment https://forums.phpfreaks.com/topic/211039-big-int-int-medium-int-small-int-and-tiny-int/#findComment-1100750 Share on other sites More sharing options...
fenway Posted August 18, 2010 Share Posted August 18, 2010 And in general, never use BIGINT. Link to comment https://forums.phpfreaks.com/topic/211039-big-int-int-medium-int-small-int-and-tiny-int/#findComment-1100751 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.