Advertisements
Advertisements
Question
Can we have a CHAR or VARCHAR data type for contact number (mobile, landline)?
Short Answer
Advertisements
Solution
Yes, we can use CHAR or VARCHAR data type for storing contact numbers (mobile or landline).
A contact number should generally be stored as a CHAR or VARCHAR, not as an integer, because it may contain a country code (+91), leading zeros, spaces, or hyphens.
MobileNo VARCHAR(15)
shaalaa.com
Is there an error in this question or solution?
