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

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