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: Karl Hewlett <fake_address_at_auckland.ac.nz>
Date: 2000/04/14
Message-ID: <8d5d2u$5r5$1@scream.auckland.ac.nz>#1/1

The rule of thumb I use is that only fields that have calculations performed on them are stored in any numeric format.

Karl

Beatlebum <Beatlebum_at_MailandNews.com> wrote in message news: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 Fri Apr 14 2000 - 00:00:00 CDT

Original text of this message

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