Hello http://www.bitboost.com/ref/international-address-formats.html http://www.census.gov/geo/www/standards/scdd/AddressStandardV2_April%2017_2003.htm Rock solid solution will be propably too heavy. Propably you can find some more national specific sources. Regards Pavel 2007/7/19, Bruno Lavoie <bruno.lavoie@xxxxxxxxx>:
Hello guys, I am currently designing a database which has several tables (e.g. a Customer table) which include address information such as street address, city, state, country code, and zip code, and phone number information in each record. We need to make the schema for these tables sufficient to accomodate entries for international customers. I figured someone else reading this may have developed a database with similar international concerns and have some suggestions that would help us avoid any pitfalls as we move forward. Is a standard for international addresses exists in the case of database design? in representation? I want to be rock solid.... Any suggestions/help is appreciated! Thanks!! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
