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