CLOB > -----Original Message----- > From: Daniel Kessler [mailto:[EMAIL PROTECTED] > Sent: 29 April 2005 13:13 > To: CF-Talk > Subject: longer than a varchar2 > > 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:205052 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