MySQL Forums
Forum List  »  Newbie

Re: Question about "bit length"
Posted by: Roland Bouman
Date: July 11, 2005 01:35PM

Hi!

I'm not sure want you want to know about 'a good value for and index', but:

An INT UNSIGNED uses 4 bytes of storage and the numeric ranges are between and including 0 and 4294967295.

The 5 between the parentheses specifies the maximum display length:

manual 11.2, Numeric types:

Another extension is supported by MySQL for optionally specifying the display width of an integer value in parentheses following the base keyword for the type (for example, INT(4)). This optional display width specification is used to left-pad the display of values having a width less than the width specified for the column.

The display width does not constrain the range of values that can be stored in the column, nor the number of digits that are displayed for values having a width exceeding that specified for the column.

end man.

Options: ReplyQuote


Subject
Written By
Posted
Re: Question about "bit length"
July 11, 2005 01:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.