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
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
