From: Dan Nelson
Date: June 10 2003 5:40pm
Subject: Re: INT type
List-Archive: http://lists.mysql.com/mysql/142309
Message-Id: <20030610174011.GA2458@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jun 10), Mojtaba Faridzad said:
> I defined a field as INT type but when I checked in phpMyAdmin, it showed
> INT(11). Still I cannot enter higher 2147483647 (signed int) in this field.
> Does 11 mean that MySQL needs 11 bytes to keep it?  I changed the length to
> 2 (for example) but still I could save higher values such as 999 in it!!!
> What does length mean in INT(length)?

Display width.  If you need to store a larger value, use a different
integer type.

http://www.mysql.com/doc/en/Column_types.html

-- 
	Dan Nelson
	dnelson@stripped