INT Field displaying strange results
Posted 20 October 2006 - 01:24 PM
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,
Posted 20 October 2006 - 04:26 PM
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
Posted 20 October 2006 - 04:36 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users