Varchar2(4000) Using 8i 4000 is your limit, using 7 2000 is your limit.
Your next option would be to use a LOB like a CLOB which has I believe a 2 or possible a 4 gig limit. > -----Original Message----- > From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 24, 2002 2:44 PM > To: CF-Talk > Subject: OT: Long text fields > > Hi. I am developing with an Oracle back end. I want to have a > "miscellaneous notes" field in a table. I want to use some sort of > HTML-editor tag as the front end for this field, and imagine that it will > hold up to about 3000 characters. What datatype should I use in the back > end, and what size limit does that type have? Is this a more complicated > question than I think? > > Thanks, > Matthieu > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
