floridaflatlander Posted September 5, 2012 Share Posted September 5, 2012 I've searched for this and it seems it should work but it doesn't. As I under stand it, INT stores an integer in total up to 2 billion plus and if a length is assigned like int( 8 ) only 8 charcters of that length will be displayed. But my problem is if I put in more than 8 charactors they are all displayed, can someone tell me whats up? Thanks Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted September 5, 2012 Share Posted September 5, 2012 See the second paragraph: http://dev.mysql.com/doc/refman/5.0/en/numeric-type-attributes.html Quote Link to comment Share on other sites More sharing options...
floridaflatlander Posted September 5, 2012 Author Share Posted September 5, 2012 The display width does not constrain the range of values that can be stored in the column. Nor does it prevent values wider than the column display width from being displayed correctly. So this means I have to limit characters on input? Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted September 5, 2012 Share Posted September 5, 2012 Zacly. Quote Link to comment Share on other sites More sharing options...
floridaflatlander Posted September 5, 2012 Author Share Posted September 5, 2012 Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.