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 Link to comment https://forums.phpfreaks.com/topic/268026-length-if-int-out-put/ 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 Link to comment https://forums.phpfreaks.com/topic/268026-length-if-int-out-put/#findComment-1375490 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? Link to comment https://forums.phpfreaks.com/topic/268026-length-if-int-out-put/#findComment-1375501 Share on other sites More sharing options...
Pikachu2000 Posted September 5, 2012 Share Posted September 5, 2012 Zacly. Link to comment https://forums.phpfreaks.com/topic/268026-length-if-int-out-put/#findComment-1375571 Share on other sites More sharing options...
floridaflatlander Posted September 5, 2012 Author Share Posted September 5, 2012 Thanks Link to comment https://forums.phpfreaks.com/topic/268026-length-if-int-out-put/#findComment-1375605 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.