Hi.
On Mon, Nov 26, 2001 at 02:45:26PM -0500, [EMAIL PROTECTED] wrote:
> I have a rhetorical question.
>
> I'm learning as much as I can about MySQL. There is one little detail
> that I don't *have* to know the answer to, but I'm curious about. Don't
> waste your time replying if you're busy.
>
> It appears that the display width is an option for certain types of
> numeric columns. For instance, "SMALLINT(3) UNSIGNED" which would be a
> "number from 0 to 65535 with a display size of 3 characters in width,
> unless the value was greater than 3 characters in width, in which case
> all of the characters would be displayed."
>
> What is the point of specifying a width? I only see it being useful in
> combination with the ZEROFILL attribute, which would add leading zeros
> up to the display width if the number is fewer characters than the
> display width. Otherwise, it seems to serve little purpose.
Almost. You are correct with all your conclusions, except that it can
serve an application as hint about the display width, which can be
used to avoid changing the display width while different "pages" of
content are displayed.
The main use is for zerofill, though.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
