You don't have to enable clob to use text or ntext data types but if you don't then CF will crop any input to those fields that exceeds a certain length. I can't remember what the length is that CF crops at but I have experienced this. Not sure about blob.
----- Original Message ----- From: "Jacob Munson" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, March 07, 2007 10:57 PM Subject: SQL Server DSN, text data type, CLOB is required? A co-worker of mine just told me that in order to use the text data type in SQL Server, you have to enable CLOB and BLOB in the data source in CFAdmin. Is this true? I need to use the text data type because my users potentially could enter a large amount of text (> 8000 chars). -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
