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: Fernando <spamers_at_must.die>
Date: 2000/04/13
Message-ID: <g5vbfsk9otqnajdhhg5r45qp6r79a97n6b@4ax.com>#1/1

On Thu, 13 Apr 2000 10:19:31 -0400, "Jon M." <Jonatmfr_at_eei.org> wrote:

>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.

I guess he isn't sure if storing the states as strings (and repeating n times the same string) or using a number: a foreign key from a table consisting in state_id and state_name

//-----------------------------------------------
//	Fernando Rodriguez Romero
//
//	frr at mindless dot com
//------------------------------------------------
Received on Thu Apr 13 2000 - 00:00:00 CDT

Original text of this message

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