Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Newbie Question: field length
Johan,
For my two cents, I would create a table to hold the zipcode, city, province/state, country, and international calling code. For the telephone, depending on how your users will be entering the data, I usually break it down as international calling code, area code and 7 digit number. Prefill the international and area codes based on the lookup of the zip code. Save a considerable amount of data entry and possible entry errors over the long run.
HTH. Brian.
"J. Park" <johan_park_at_hotmail.com> wrote in message
news:89j0hn$bnu$1_at_tesla.a2000.nl...
> I'm making my first oracle database
> and I am wondering for example
> what should be the the length of some fields
>
> this what I have at this moment.
> firstname (50 chars)
> surname (50 chars)
> initials (15 chars)
> telephone (20 chars)
> fax (20 chars)
> street (50 chars)
> zipcode (10 chars)
> city (50 chars)
> country (50 chars)
>
> Are they to long ( or to short ) ?
>
> thanks in advance,
> Johan (from Amsterdam, the Nethelands)
>
>
>
Received on Wed Mar 01 2000 - 00:00:00 CST