We want to store 10 digit mobile number i.e.9999999999. Should it be numeric or string datatype? We don't want to do any calculative or manipulation operation on this
Which is better memory and performance wise?
ITU-T recommendation E.164 says you need 3 digits for the country code and up to 15 digits for the directory number within the country dialing plan.
And, many people add some punctuation. For example:
+1.212.555.1212 is a North American number. It could also be rendered (212) 555-1212 in a North American centric app.
32 characters of text should do the trick worldwide.
DO NOT use a number, or you'll be sorry. I was: two things.
2.12555E+09
That's almost as stupid as SIRI telling me you have call from two bllion, one hundred twenty five million....Telephone directory numbers are not numeric data types. Take a look at this: Falsehoods Programmers Believe About Telephone Numbers.