OT: Address Fields

Hi everyone,

Just wondering if anyone has any tips on the best way to represent
international addresses (ie from any country) in a database?

It seems to me that the most flexible way is to use a text field to hold
everything, apart from the country which suits a varchar? and perhaps have
another dedicated varchar field to hold USA ZIP codes / UK post codes for
easy searching?

Advice from those who have successfully created a scheme with enough
flexibility and structure to be useful would be greatly appreciated.

Thanks,

Sam.

---
Posted via news://freenews.netfront.net
Complaints to news@netfront.net