[UPHPU] MySQL int lenght?

[William Attwood]

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
<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
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net
>