We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!

zip code field is too short

- 253 Posts
eastbind Reply #1, 20 years, 4 months ago

Hi, all.

I suggest making zip field varchar(10) at least.
Postal code format in Japan is
NNN-NNNN N=Numeric

And, please refer to following URL about zip in other countries,
http://en.wikipedia.org/wiki/List_of_postal_codes

Regards