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

Noons wrote:
> 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?

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.org