Re: Newbie Question: field length

Generally, you make them long enough that you don't think you will ever exceed them. Personally, I don't think you would ever get a first name that long, but that shouldn't be a big deal. (Are these VARCHAR2 type or CHAR? If they are CHAR with an 8.x database, that means the variables will always be returned as 50 character strings, not as the size entered. VARCHAR2 will return the size as entered.)

Overall, the setups look fine to me. The biggest zip code that I know of is in the US with XXXXX-YYYY, so you are exactly on there. The others have enough room that you should never exceed them, so it should be fine. (Assuming you are not going to be cramped for size with too many rows.)

Terry Steyaert
steyaert_at_my-deja.com

In article <89j0hn$bnu$1_at_tesla.a2000.nl>,   "J. Park" <johan_park_at_hotmail.com> wrote:
> 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)
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 01 2000 - 00:00:00 CST