Re: integer

[Rob Wultsch]

On Tue, Jun 3, 2008 at 4:16 AM, Krishna Chandra Prajapati
<prajapatikc@stripped> wrote:
> Hi,
>
> How int is eqivalent to int(11)
>
> Thanks,
> --
> Krishna Chandra Prajapati
>

" 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. "
http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

-- 
Rob Wultsch
wultsch@stripped