Received: from mailbox2.ucsd.edu (mailbox2.ucsd.edu [132.239.1.54]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBC2QOm91634 for ; Tue, 11 Dec 2001 21:26:24 -0500 (EST) (envelope-from ghoffman@ucsd.edu) Received: from smtp.ucsd.edu (smtp.ucsd.edu [132.239.1.49]) by mailbox2.ucsd.edu (8.12.1/8.12.1) with ESMTP id fBC2QSe2028860 for ; Tue, 11 Dec 2001 18:26:28 -0800 (PST) Received: from irpsmail.ucsd.edu (irpsmail.ucsd.edu [132.239.21.3]) by smtp.ucsd.edu (8.9.3/8.9.3) with ESMTP id SAA05245 for ; Tue, 11 Dec 2001 18:26:28 -0800 (PST) Message-id: Date: Tue, 11 Dec 2001 18:30:25 -0800 Subject: Best practice for international addresses To: pgsql-php@postgresql.org From: "Gary Hoffman" MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200112/11 X-Sequence-Number: 786 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/ * **************************************************************************