westminster86 Posted April 8, 2008 Share Posted April 8, 2008 Im having trouble inserting a telephone number into a table. For some reason its taking off the 0 at the beginning of the number. Why is this? Quote Link to comment Share on other sites More sharing options...
zenag Posted April 8, 2008 Share Posted April 8, 2008 can u show ur ur database structure? Quote Link to comment Share on other sites More sharing options...
friedemann_bach Posted April 8, 2008 Share Posted April 8, 2008 I guess the phone number field in your database is an INTEGER field that omits leading zeros (00394567123 becomes 394567123). Phone numbers should be treated as strings - use VARCHAR instead of integer. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.