I'll second that - any text too big for varchar2 should just go into a CLOB so you don't have to worry about its length any more.
-----Original Message----- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, 29 April 2005 7:20 To: CF-Talk Subject: RE: longer than a varchar2 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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205054 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
