Gabriel PREDA wrote:
<snip>
So AFAIK this is the purpose of the "length"...in INTEGER columns.
-- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer
Olaf,
As Gabriel so eloquently demonstrated, the LENGTH parameter only affects
how the numbers are displayed, not how they are stored.
Even if you declare a field to be INT(1) then whatever value you put
into it will take up just as much room on disk and in memory as any
other INT. The only difference is how the number is rendered as part of
a result.
--
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN
Are you MySQL certified? www.mysql.com/certification
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
