Re: Help, my developers are killing me with varchar2(4000)

On Aug 14, 11:45 am, xhos..._at_gmail.com wrote:
> gazzag <gar..._at_jamms.org> wrote:
> > On 13 Aug, 21:13, DA Morgan <damor..._at_psoug.org> wrote:
>
> > > Hopefully you aren't expecting the auto companies to now design cars
> > > that protect you from teenage drivers.
> > > --
> > > Daniel A. Morgan
> > > Oracle Ace Director & Instructor
> > > University of Washington
> > > damor..._at_x.washington.edu (replace x with u to respond)
> > > Puget Sound Oracle Users Groupwww.psoug.org
>
> > Of course not.  But I don't expect the throttle to default to "full"
> > either.
>
> So what should the default size of a varchar2 be then?  7?  12?  23?  0?
>
> Xho
>
> --
> --------------------http://NewsReader.Com/--------------------
> The costs of publication of this article were defrayed in part by the
> payment of page charges. This article must therefore be hereby marked
> advertisement in accordance with 18 U.S.C. Section 1734 solely to indicate
> this fact.

We dont use a single default but rather when we do our data modeling, we use domains based on the intent of the column. "names", for example might be 50, "codes", maybe 10, "descriptions" might be 1000, etc. Received on Thu Aug 14 2008 - 14:12:30 CDT