leolanksford Posted October 20, 2006 Share Posted October 20, 2006 Hi all,I have a table which stores phone numbers amongst other details, currently the "phone" field is set up as: INT(20), Null = Yes, Default = 0I recently tried to add the number '07000446639' to the db, but when i do this the db changes it to '2147483647'Would any have any idea why it would be doing this?Any help would be great,Many thanksLeo Link to comment https://forums.phpfreaks.com/topic/24541-int-field-displaying-strange-results/ Share on other sites More sharing options...
fenway Posted October 20, 2006 Share Posted October 20, 2006 Maybe I don't know what you mean be "add the number to the db"? Link to comment https://forums.phpfreaks.com/topic/24541-int-field-displaying-strange-results/#findComment-111914 Share on other sites More sharing options...
leolanksford Posted October 20, 2006 Author Share Posted October 20, 2006 What i was tying to say was that when i add the number 07000446639 into the column 'PhoneNumber' for a specific record, the db changes what i have entered to '2147483647'i have tried entering the number without the 9 at the end and it works fine, but as soon as i add the 9 the db changes the whole number to 2147483647 Link to comment https://forums.phpfreaks.com/topic/24541-int-field-displaying-strange-results/#findComment-111921 Share on other sites More sharing options...
fenway Posted October 20, 2006 Share Posted October 20, 2006 Two things: first, it sounds like it might be too large, though this shouldn't be an issue for INT; second, if you want to keep that leading zero, you'd have to use ZEROFILL or switch to a CHAR column, which I would recommend anyway, since you can't do math with this field. Link to comment https://forums.phpfreaks.com/topic/24541-int-field-displaying-strange-results/#findComment-111932 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.