List:General Discussion« Previous MessageNext Message »
From:gerald_clark Date:October 17 2005 3:33pm
Subject:Re: Confusion Over Numeric Types
View as plain text  
Shaun wrote:

>Hi,
>
>When I create a table using my ISP's web control panel and I create a column 
>with a type of TINYINT it automatically creates a column with a value of 
>TINYINT(4).
>
>After looking at the documentation on the MySQL site it is not exactly clear 
>what this means:
>
>http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
>
>Is TINYINT(4) the same as an INT(4)?
>
>Thanks for your advice. 
>
>
>  
>
TINYINT(4) means a type that holds a value for -128 to 127 displayed 
with max (4) character positions.
The part in parenthesis is the input/output display parameter, not the 
number of bytes of storage.

Thread
Confusion Over Numeric TypesShaun17 Oct
  • Re: Confusion Over Numeric TypesDirk Kredler17 Oct
  • Re: Confusion Over Numeric Typesgerald_clark17 Oct