Re: varchar2(size)

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Tue, 29 Sep 2009 17:36:10 -0700 (PDT)
Message-ID: <54282333-3dbe-43f7-a21f-5c021a41c436_at_l13g2000yqb.googlegroups.com>

On Sep 29, 7:46 pm, indytoatl <indyto..._at_gmail.com> wrote:

snip

> If I have a table with 200 fields that are all variable length what
> would be the drawback be of making them all varchar2(100) so that I
> don't have to guess a number for each field. The form users fill out
> already has contraints for the same fields (ie, Last Name Field on
> form has 20 space limit.).

Why don't you just make them all 2000 characters apiece since 100 might be too small?

Most properly designed database tables do not have 200 columns in them.

If the maximum size of a last name is 20 spaces ... why would you not use varchar2(20)?

Has there been an ERD completed for this application? Received on Tue Sep 29 2009 - 19:36:10 CDT