On 10/25/06, Jakob S. [email protected] wrote:
On Oct 25, 2006, at 21:02, Ben J. wrote:
How do you store international addresses in a database? What fields do
you need? I have no idea what addresses are like all over the world.
I suppose it depends on what you need them for. Basically all you
need is one field in the database and a text area in your UI. I don’t
know of any address that won’t fit into that schema.
About the only thing that really changes much is that not every
country has a ZIP code or equivalent.
Having 3-4 lines for an address or just a text field is normally
but you do want to be capturing concepts like City/State (though
allowing for the fact that different countries have different names for
their primary geographic administrations, like province, county,