From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Bruno Lavoie" <bruno(dot)lavoie(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Database design : international postal address |
Date: | 2007-07-19 06:01:37 |
Message-ID: | 162867790707182301w7a35c369h10b5c2d4e2806155@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)lavoie(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mikko Partio | 2007-07-19 06:08:27 | Re: Unexpected crash |
Previous Message | Mikko Partio | 2007-07-19 05:58:06 | Re: Unexpected crash |