Re: varchar2(size)
From: gazzag <gareth_at_jamms.org>
Date: Wed, 30 Sep 2009 01:48:52 -0700 (PDT)
Message-ID: <f06f2861-6a14-4a1f-8a45-2ee42287f6dd_at_j4g2000yqa.googlegroups.com>
On 30 Sep, 00:46, indytoatl <indyto..._at_gmail.com> 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.).
Date: Wed, 30 Sep 2009 01:48:52 -0700 (PDT)
Message-ID: <f06f2861-6a14-4a1f-8a45-2ee42287f6dd_at_j4g2000yqa.googlegroups.com>
On 30 Sep, 00:46, indytoatl <indyto..._at_gmail.com> 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