Re: Zip Code Fields
| From: | Chris | Date: | Wed, 08 Sep 2004 17:44:39 +0000 |
| Subject: | Re: Zip Code Fields | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36112@lists.php.net to get a copy of this message | ||
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