Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!helios!bcm!dimacs.rutgers.edu!seismo!uunet!zaphod.mps.ohio-state.edu!pacific.mps.ohio-state.edu!linac!att!pacbell.com!ames!pasteur!ucbvax!ucdavis!csusac!unify!Unify.com!dgh
From: dgh@Unify.com (David Harrington)
Newsgroups: comp.databases
Subject: Re: International address format wanted
Message-ID: <1991Jan31.131325@Unify.com>
Date: 31 Jan 91 21:13:25 GMT
References: <857F*%@linac.fnal.gov>
Sender: news@Unify.Com (news admin)
Reply-To: dgh@Unify.com (David Harrington)
Organization: Unify Corporation, Sacramento, CA, USA
Lines: 30

In article <857F*%@linac.fnal.gov>, kfreytag@mdtf11.fnal.gov (Kelley
Trombly-Freytag) writes:
>
> The most general idea I've come up with is:
> 
>             Field Name        Type
>             -------------------------
>             address_1        char(40)
>             address_2        char(40)
>             address_3        char(40)
>             address_4        char(40)

Why not add:
              post_code        char(15)
 
>             country          char(30)
> 
> Does anyone have any ideas, experience, or pointers to references I 
> could use?
> 
> AtDhVaAnNkCsE
> ----------------------------------------------------------------------
> Kelley Trombly-Freytag                 Internet: kfreytag@mdtf11.fnal.gov
> Fremilab, Batavia, IL

--
David Harrington                                  internet: dgh@eire.unify.COM
Unify Corporation                          ...!{csusac,pyramid}!unify!eire!dgh
3870 Rosin Court                                        voice: +1 916 920-9092
Sacramento, CA 95834                                      fax: +1 916 921-5340