Re: varchar2(size)

From: Malcolm Dew-Jones <>
Date: 30 Sep 2009 12:19:48 -0700
Message-ID: <4ac3af54$>

John Hurley ( wrote:
: On Sep 29, 7:46=A0pm, indytoatl <> 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)?

What if you need to save Mr. Seamus Wolfeschlegelsteinhausenbergerdorff's name in your database? What if his daughter then gets married and hyphenates her name with her husband's?

Many "maximum" sizes are really just arbitrary guesses. Received on Wed Sep 30 2009 - 14:19:48 CDT

Original text of this message