Use a varchar2...It has 4K limit (or close to it). I had done the same thing but went over the 4K limit. I had to use a CLOB instead.
Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 -----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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists