[UPHPU] MySQL int lenght?
localstatic at localstatic.com
Wed Jul 30 12:14:04 MDT 2008
I forgot to include the URL I got that from:
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:
>>> 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
>> IRC: #uphpu on irc.freenode.net
More information about the UPHPU