What data type should you choose for a zip code field in a table?
Answers
Answered by
9
Answer
Alphanumeric, varchar, string
Explanation
Though it seems fine storing the zipcode as an integer or a numeric datatype, but there will be problems as:
- Zip Codes have extensions, meaning they can be 67854-9865 but you cannot store a dash in a numeric datatype.
- Zip codes can start with a zero, if you store it as an int you are going to lose the leading zero (leftmost zero before a non-zero number)
Answered by
0
Answer:
Text, memo and number
Explanation:
Similar questions