468,550 Members | 2,300 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,550 developers. It's quick & easy.

telephone number column type

What is the recommended way of storing 10 digit phone numbers? I like
bigint(10), but it seems most are using varchar? Or I've also seen 2
int columns, one for area code and another for the rest of the digits?

I wish phone numbers had their own column type, so I can send
123-456-7890 or (123) 456-7890 or whatever and have mysql do the right
thing.
Jul 19 '05 #1
0 1671

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ashish | last post: by
2 posts views Thread by chris | last post: by
1 post views Thread by Ed Dror | last post: by
9 posts views Thread by =?Utf-8?B?TWlrZTk5MDA=?= | last post: by
1 post views Thread by silent15 | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.