Advertisements
Advertisements
प्रश्न
Can we have a CHAR or VARCHAR data type for contact number (mobile, landline)?
लघु उत्तरीय
Advertisements
उत्तर
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
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
