With MySQL you could do this:
MEDIUMINT(5) UNSIGNED ZEROFILL
Most databases (I think) would have an equivalent of this if you're using something else.
Chris
Aaron Todd wrote:
Just curious, but what kind of field is everyone using to store a Zip Code. I set mine to Medium Integer with a max of 5 digits, but for zip codes that begins with 0 the 0 is knocked off. The only solutiuon I can think of is to make the field a text field. Does anyone have a better solution?
Thanks,
Aaron
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
