mysql zip code
mysql zip code
- Started
- Last post
- 3 Responses
- jpea
anyone know of a way to work with a zip code in mysql that begins with 0? (or any type of INT data that begins with 0 for that matter).
when i import a csv it strips out the 0 at the beginning of any zip code.
- Nairn0
Is a zip code strictly an integer? Would var/char not suffice?
(my glaring ignorance of datatypes showing through here)
Are zipcodes a set length? If so - could you simply add a zero prefix to any codes that fall short of the standard length?
- jpea0
oh yeah, good point. thanks :)
- UndoUndo0
what Nairn said.
i'm impressed nairn