tinyint(1) and tinyint(4), which one is bigger?


MySQL: tinyint(1) and tinyint(4), which one is bigger?

For numeric types length modifier is actually display width, which has nothing to do with what can be stored in field. Yes, that’s it – both TINYINT(1) and TINYINT(4) can store values in range -128..127 (or for unsigned values 0..255), and are absolutely identical datatypes, with one small twist

Related Posts