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