Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
irealms
- Forum Contributor
- Posts: 215
- Joined: Mon Apr 28, 2003 7:10 am
- Location: Leeds
Post
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?
-
Wayne
- Forum Contributor
- Posts: 339
- Joined: Wed Jun 05, 2002 10:59 am
Post
by Wayne »
what is your table structure? and can you give an example of the completely changed numbers?
-
[]InTeR[]
- Forum Regular
- Posts: 416
- Joined: Thu Apr 24, 2003 6:51 am
- Location: The Netherlands
Post
by []InTeR[] »
The field is a integer?
Make it a varchar.
-
irealms
- Forum Contributor
- Posts: 215
- Joined: Mon Apr 28, 2003 7:10 am
- Location: Leeds
Post
by irealms »
fixed it, thought about using varchar but that allows for character entry. I used Decimal instead and it works fine now, thanks
