By default they can hold up to 4gig... But I think 32760 is a good start.
The oracle datasource also needs to be setup in CF Admin with the "Enable long text retrieval (CLOB)" option checked. Otherwise, only 4000 characters will be pushed into the db on insert (probably the reason the 4000 limit is there... Cheers, Craig -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brendan Sisson Sent: Tuesday, 16 March 2004 9:50 AM To: FarCry Developers Subject: [farcry-dev] Re: Database Problem Nathan Mische wrote: > db.type = 'CLOB'; > db.length = 4000; > stPropTypes['longchar'] = duplicate(db); Nice pick up Nathan, this would be the problem. Anyone know a good default size for Oracle CLOB fields? -Brendan http://farcry.daemon.com.au --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
