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. Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.