Web11 Jun 2013 · 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) …
sql - Storing phone numbers in DB - Stack Overflow
Web7 Oct 2024 · I think you should have to use Varchar (n) (for example Varchar (25)) as datatype of mobile number because some times probably you will have to store mobile number as in 111-111-1111 so at that time int will not work, but by using varchar () you will never get exception. Tuesday, May 8, 2012 1:47 AM Anonymous 1,305 Points 0 Sign in to … WebPhone numbers are a common field to store in a database. However, storing them as integers can cause problems.In this video, I'll demonstrate an example of s... is everything everywhere all at once horror
[Solved] Mobile Number data type in Sql Server - CodeProject
Web28 Jan 2024 · If you bother about performance (using a big dataset) then you should choose bigint but do read this first Google says never store phone numbers as numeric data If … Web24 Dec 2015 · I would typically store phone numbers as text. Having said that, it really depends how critical your phone number column is. If you are running automated dialers … Web2 Jul 2024 · These phone numbers have a fixed schema and will never exceed 10 digits. Storing phone numbers in a CHAR field with a size of 10 would work well for phone numbers. Variable Character – VARCHAR (X) Unlike CHAR data types, VARCHAR data types are flexible. VARCHAR data types allow you to define a maximum size, not a fixed size. is everything evolving into crabs