Re: Help, my developers are killing me with varchar2(4000)
Date: Thu, 14 Aug 2008 18:17:33 -0700
> xhoster_at_gmail.com wrote,on my timestamp of 15/08/2008 4:45 AM:
>> gazzag <gareth_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.
>>> 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?
> does it really matter? it's variable length anyway:
> the size is a constraint, not an allocation issue.
As with many things ... depends ...
For example when working with bind variables VARCHAR2s are rounded to the next highest length that can be 32 bytes, 128 bytes, 2000 bytes, or 4000 bytes.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Aug 14 2008 - 20:17:33 CDT