Re: varchar2(size)

From: gazzag <>
Date: Wed, 30 Sep 2009 01:48:52 -0700 (PDT)
Message-ID: <>

On 30 Sep, 00:46, indytoatl <> wrote:
> 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 guess? As John said, you've already said that you know that the Last Name field, for example, has a 20 character limit, so specify VARCHAR2(20) for that field. Size the rest of the fields appropriately.

HTH -g Received on Wed Sep 30 2009 - 03:48:52 CDT

Original text of this message