Database design : international postal address
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!!
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@gmail.com>:
Show quoted text
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