Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Feb 2012
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    The diference between tinyint(4) and tinyint(3)?

    1. What is tinyint(4)?
    2. Is 4 the number of digits?
    3. Could you tell me the diference between tinyint(4) and tinyint(3)?
    4. Is it possible to have tinyint(7) ?

    Thank u very much!

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,994
    Thanks
    4
    Thanked 2,662 Times in 2,631 Posts
    The 4 in the tinyint should represent the zerofill of the number. You can have a tinyint(50) if you want. All that changes is the left padding of 0's that appear before the number stored. So tinyint(4) with a value of 56 would be 0056. It won't alter the range you are allowed. I believe that the zerofill only works with unsigned numbers, so with a tinyint you can still only have 0 - 255 as a valid range.

    Edit:
    After a quick test the number does represent the display range regardless of signed/unsigned. It does not however appear to allow zerofill unless the number is unsigned, so if you were to set tinyint(0) that would result in tinyint(3) since you need three digits to display the range of tinyint. When its signed, it gives me tinyint(4).
    So it will automatically dictate the minimum size for you based on the datatype and sign, but anything above and beyond is for zerofill. This would also indicate that it merely represents the number of chars required to display it, rather than to store it (since a tinyint can fit in a single byte).
    Last edited by Fou-Lu; 01-13-2013 at 04:33 PM.

  • #3
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,869
    Thanks
    79
    Thanked 4,421 Times in 4,386 Posts
    And zerofill is, in my opinion, a bad idea.

    It gives the mistaken impression that MySQL is actually storing numbers with leading zeroes.

    Nothing could be further from the truth!

    INTERNALLY, there is NO DIFFERENCE between TINYINT(0) and TINYINT(50).

    The *ONLY* difference is that, when you SELECT a field declared as TINYINT(50) ZEROFILL, MySQL must convert the *NUMBER* in the field to a *STRING*! Because ONLY strings can actually have zero fill.

    On top of all that, when you USE a ZEROFILL field in a server-side language, such as PHP or ASP or JSP, you many be surprised at what the actual value is.

    At least in ASP, for example, the zero fill is *REMOVED* from the number and the number is treated as a DOUBLE (a.k.a. REAL) number, not as an integer, at all.

    So the best thing you can do, in my opinion, is *NEVER* use ZEROFILL.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •