Received: from tomts9-srv.bellnexxia.net (tomts9.bellnexxia.net [209.226.175.53]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBC3tqm94498 for ; Tue, 11 Dec 2001 22:55:52 -0500 (EST) (envelope-from fbax@sympatico.ca) Received: from ACER ([65.93.8.66]) by tomts9-srv.bellnexxia.net (InterMail vM.4.01.03.16 201-229-121-116-20010115) with SMTP id <20011212035555.HTAF29230.tomts9-srv.bellnexxia.net@ACER>; Tue, 11 Dec 2001 22:55:55 -0500 Message-Id: <3.0.6.32.20011211225516.0079a630@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (32) Date: Tue, 11 Dec 2001 22:55:16 -0500 To: "Gary Hoffman" From: Frank Bax Subject: Re: Best practice for international addresses Cc: pgsql-php@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200112/12 X-Sequence-Number: 787 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 >