telephone number column type

[chris]

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 [phone] or whatever and have mysql do the right
thing.

[Aggro]

chris wrote:

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 [phone] or whatever and have mysql do the right
thing.

I would recommend using varchar. Then it should be quite easy to put the
data in the format you like, and read it out in the same format you put
it in.

[Aggro]

chris wrote:

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 [phone] or whatever and have mysql do the right
thing.

I would recommend using varchar. Then it should be quite easy to put the
data in the format you like, and read it out in the same format you put
it in.