Mobile Number data type in Sql Server

Question

0.00/5 (No votes)

See more:

Hi,

I have to create a column in sql server database for Mobile number?

What data type i have to use to store mobile numbers?
Purely it should store only 10 digits no special chars and alphabets.

Posted 10-Jun-13 23:44pm

Rockstar_

Updated 1-Dec-16 4:20am

Add a Solution

Comments

gvprabu 11-Jun-13 5:46am

yes, You can use VARCHAR(10) or CHAR(10) datatype for this, But Don't use like NUMERIC(10,0) or other datatypes

Rockstar_ 11-Jun-13 5:47am

Why?

Rockstar_ 11-Jun-13 5:49am

If i write varchar(10), then it accepts special chars and alphabets also?

gvprabu 11-Jun-13 5:50am

yes correct, then u will check this in front end or back end while all values are numbers or not.

gvprabu 11-Jun-13 5:53am

Hi,
SELECT ISNUMERIC('123A4567890'), ISNUMERIC('1234567890')
Check like this....

gvprabu 11-Jun-13 5:53am

This Function will return '1' then valid Number else its invalid Number

gvprabu 11-Jun-13 6:02am

I updated my solution, check and choose the Datatype

gvprabu 11-Jun-13 6:09am

http://www.codeproject.com/Articles/20434/Telephone-Numbers-in-SQL-Server-2005-Part-1-The-Da
Check this and choose correct datatype as per your request...

3 solutions

Solution 2

Telephone datatype is set to numeric

Posted 13-Jun-13 20:56pm

Nirav Prabtani

Solution 3

create table mobile (Mobile_Number varchar(15))
insert into mobile values(9934567890)

Posted 1-Dec-16 4:20am

Member 12881390

Comments

CHill60 2-Dec-16 11:46am

No different to Solution 1 posted over 3 years ago and then you use the wrong type in the insert statement

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

gvprabu · Accepted Answer · 2013-06-10T23:49:00

Hi,

You can use VARCHAR(10) datatype for this.

Check the following links....
Telephone Numbers in SQL Server 2005: Part 1 – The Data Type[^]
Telephone Numbers in SQL Server 2005: Part 2 – Formatting[^]
what data type can i use to store phone numbers in c# and sql server 2005[^]
SQL Server data types for telephone number and email address[^]
What datatype should be used for storing phone numbers in SQL Server 2005?[^]

Regards,
GVPrabu