INT Field displaying strange results

[leolanksford]

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

[fenway]

Maybe I don't know what you mean be "add the number to the db"?

[leolanksford]

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

[fenway]

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.