From: Frank Bax <fbax@sympatico.ca>
To: Gary Hoffman <ghoffman@ucsd.edu>
Cc: pgsql-php@postgresql.org
Subject: Re: Best practice for international addresses
Date: Tue, 11 Dec 2001 22:55:16 -0500
Message-ID: <3.0.6.32.20011211225516.0079a630@pop6.sympatico.ca> (raw)
In-Reply-To: <fc.00249f0e002f8d5e00249f0e002f8d5e.2f8d81@irpsmail.ucsd.e du>
I was looking at Cart software on the weekend and found that "The Exchange
Project" used an "address format" table:
# 1 - Default, 2 - USA, 3 - Spain, 4 - Singapore
1 $firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country
2 $firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country
3 $firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country
4 $firstname $lastname$cr$streets$cr$city ($postcode)$cr$country
The country table (and every table containing an address) had a field to
indicate which address format to use.
Frank
At 06:30 PM 12/11/01 -0800, Gary Hoffman wrote:
>Can anyone refer me to a source of advice for setting up an address
>database that is general enough to handle postal addresses from any
>country of the world? At our graduate school, we get mail from all over,
>but particularly countries in the Pacific region. We have built several
>address book type databases, mostly on the U.S. model, but extended with a
>few fields. But we have never been able to format the output properly for
>all countries. We always seem to be fiting the square pegs from various
>countries into the round holes of whatever field schema we choose.
>
>I'm not looking for a long discussion here, just a referral to a good
>source of experience and advice.
>
>Cheers,
>Gary
>
>**************************************************************************
>* Gary B. Hoffman, Computing Services Manager e-mail: ghoffman@ucsd.edu *
>* Graduate School of International Relations and Pacific Studies (IR/PS) *
>* University of California, San Diego (UCSD) voice: (858) 534-1989 *
>* 9500 Gilman Dr. MC 0519 fax: (858) 534-3939 *
>* La Jolla, CA 92093-0519 USA web: http://www-irps.ucsd.edu/ *
>**************************************************************************
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: fbax@sympatico.ca, ghoffman@ucsd.edu
Subject: Re: Best practice for international addresses
In-Reply-To: <3.0.6.32.20011211225516.0079a630@pop6.sympatico.ca>
References: <3.0.6.32.20011211225516.0079a630@pop6.sympatico.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox