I think CLOB is a good option, and you can use the LIKE operator in this kind of column. Also, don't forget cfqueryparam.
Fabio Terracini Synex Technologies Co. Consultant Fone/Fax: +55 (11) 3071-3363 [EMAIL PROTECTED] www.synex.com.br Daniel Kessler wrote: >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. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205079 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
