Hello,
I've never understood the difference between TinyInt(1) and TinyInt(4). For
CHAR data
type, I know the number enclosed in the bracket means the length of the CHAR
type.
But how does TinyInt(1) differ from TinyInt(4)? I tried to experiment with
different numbers
yet could not feel any difference:
tinyint (1) falls between {-127, 127}
tinyint (4) falls between {-127, 127}
MySQL doc says: TINYINT(M) where M Indicates the maximum display size. The
maximum
legal display size is 255. What exactly does "display size" mean? I can't
tell any difference
in SELECT output. TINYINT(1) and TINYINT(4) gives the exact same output.
Any ideas?
Jindo
---------------------------------------------------------------------
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
