Thread: 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>:
> 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
>