Ah, I am incorrect! See: http://matthom.com/archive/2006/11/28/mysql-integer-columns-and-display-width
On Wed, Jul 30, 2008 at 12:11 PM, Morgan Terry <[EMAIL PROTECTED]>wrote: > >From the MySQL docs: > Another extension is supported by MySQL for optionally specifying the > display width of integer data types in parentheses following the base > keyword for the type (for example, INT(4)). This optional display > width is used to display integer values having a width less than the > width specified for the column by left-padding them with spaces. > > The display width does not constrain the range of values that can be > stored in the column, nor the number of digits that are displayed for > values having a width exceeding that specified for the column. For > example, a column specified as SMALLINT(3) has the usual SMALLINT > range of -32768 to 32767, and values outside the range allowed by > three characters are displayed using more than three characters. > > On Wed, Jul 30, 2008 at 12:06 PM, Wade Preston Shearer > <[EMAIL PROTECTED]> wrote: > > On 30 Jul 2008, at 12:02, William Attwood wrote: > > > >> INT[Length] > >> > >> 4 bytes > >> > >> Range of -2,147,483,648 to 2,147,483,647 or 0 to 4,294,967,295 unsigned. > > > > I read that in the docs, but what does that mean? What's "[length]?" > > > > _______________________________________________ > > > > UPHPU mailing list > > [email protected] > > http://uphpu.org/mailman/listinfo/uphpu > > IRC: #uphpu on irc.freenode.net > > > > _______________________________________________ > > UPHPU mailing list > [email protected] > http://uphpu.org/mailman/listinfo/uphpu > IRC: #uphpu on irc.freenode.net > _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
