Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How should I type my data- ZIP codes and States/Regions

Re: How should I type my data- ZIP codes and States/Regions

From: Jon M. <Jonatmfr_at_eei.org>
Date: 2000/04/13
Message-ID: <38f5d71a$0$13020@wodc7nh0.news.uu.net>#1/1

In my experience it is far better to store zips as strings, especially if you ever intend to store international addresses (ever see a Canadian zip code?). I'm not sure I understand why you would even consider storing a state as a number.

HTH,
Jon Myers

Beatlebum wrote in message <39006301.200863187_at_news.supernews.com>...
>We are debating the relative merits of storing ZIP's and states as
>strings/numbers.
>
>Is there a de facto approach? What are the relative merits?
Received on Thu Apr 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US