I believe with Oracle in later than CF5 you could insert/update more than 4000 characters into a clob when using CF_SQL_CLOB. Not sure for CF5 though, for some reason I recall it failing beyond 4000 and requiring work arounds.
On Tue, 22 Mar 2005 10:44:53 -0700, Scott Brady <[EMAIL PROTECTED]> wrote: > On Sun, 13 Mar 2005 11:06:58 -0500, S. Isaac Dealey wrote: > > specifically I believe cfsqltype="cf_sql_longvarchar" > > CF_SQL_CLOB is an undocumented type that is, I believe, more > specifically designed for the "text" field, though longvarchar also > works. I'm not sure if there's a significant difference between the > two. > > Scott > -- > ----------------------------------------- > Scott Brady > http://www.scottbrady.net/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:199677 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
