[UPHPU] MySQL int lenght?
wattwood at gmail.com
Wed Jul 30 12:13:11 MDT 2008
Ah, I am incorrect!
On Wed, Jul 30, 2008 at 12:11 PM, Morgan Terry
<localstatic at localstatic.com>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
> <lists at wadeshearer.com> 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
> > UPHPU at uphpu.org
> > http://uphpu.org/mailman/listinfo/uphpu
> > IRC: #uphpu on irc.freenode.net
> UPHPU mailing list
> UPHPU at uphpu.org
> IRC: #uphpu on irc.freenode.net
More information about the UPHPU