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



Reply via email to