Hi Shaun, Am Montag, 17. Oktober 2005 16:56 schrieb Shaun: > http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html > > Is TINYINT(4) the same as an INT(4)?
No, they only have the same display width, see the following quote form the manual: "Another extension is supported by MySQL for optionally specifying the display width of an integer value in parentheses following the base keyword for the type (for example, INT(4)). This optional display width specification is used to left-pad the display of values having a width less than the width specified for the column." If you dont add a display width, MySQL uses a default display width, that is for tinyint: -127 ( sign + 1 byte storage ) The display width doesent change the bytes used to store a specific type, so tinyint always uses 1 byte for storage and int always uses 4 bytes for storage - its independ from the display width. Dirk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
