Page 1 of 1

number entry

Posted: Thu Jun 26, 2003 8:33 am
by irealms
When i enter phone numbers into my database it takes the 0 from the start of some and completely changes others? Any ideas?

Posted: Thu Jun 26, 2003 8:44 am
by Wayne
what is your table structure? and can you give an example of the completely changed numbers?

Posted: Thu Jun 26, 2003 8:51 am
by []InTeR[]
The field is a integer?
Make it a varchar.

Posted: Thu Jun 26, 2003 9:53 am
by irealms
fixed it, thought about using varchar but that allows for character entry. I used Decimal instead and it works fine now, thanks :)