what is the most suitable data type for a telephone number field in a table
Answers
Answered by
3
Hello frnd,
varchar 50 is a bit small for urls or email addresses - a domain name can be up to 63 characters long by itself and the part of an email address before the @ can be up to 255 characters long (but is unlikely to be anywhere near that big) so a varchar 255 is probably the most appropriate value (since it doesn't take any more space if the values all turn out to be less than 50 and greater than 255 is possible but so unlikely that it isn't worth catering for.
ITS ABOUT PHONE NUMBER , IF HELPFUL MARK AS BRAINLIEST ANS
Thank You
varchar 50 is a bit small for urls or email addresses - a domain name can be up to 63 characters long by itself and the part of an email address before the @ can be up to 255 characters long (but is unlikely to be anywhere near that big) so a varchar 255 is probably the most appropriate value (since it doesn't take any more space if the values all turn out to be less than 50 and greater than 255 is possible but so unlikely that it isn't worth catering for.
ITS ABOUT PHONE NUMBER , IF HELPFUL MARK AS BRAINLIEST ANS
Thank You
mahek1175:
now u only think
Answered by
3
varchar or numbers both can be used
Similar questions