Jump to content

Archived

This topic is now archived and is closed to further replies.

leolanksford

INT Field displaying strange results

Recommended Posts

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 = 0

I 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 thanks

Leo

Share this post


Link to post
Share on other sites
Maybe I don't know what you mean be "add the number to the db"?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.