I have some text that I need to keep for a database of questions. Some of this text is expected to be 5000-6000 characters. In oracle, I tried to make a varchar2(5000), but it gave me an error saying that it was too large. From searching, I've found the limit to be 4000. What now? I think that what I've read is that I need a LONG, but it wasn't clear if this was for binaries or not. If so, it seems like overkill for just 5000 chars. So, I'm looking for advice here. What type of column should I be making here?
thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205049 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
