> 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).
Straight from the documentation: CLOB - Select to return the entire contents of any CLOB/Text columns in the database for this data source. If not selected, ColdFusion MX retrieves the number of characters specified in the Long Text Buffer setting. Long Text Buffer - The default buffer size, used if Enable Long Text Retrieval(CLOB) is not selected. The default value is 64000 bytes. So, if your CLOBs will exceed the buffer size, you will need to enable CLOB. If not, you shouldn't have to. BLOBs aren't an issue here, because you're using CLOBs. http://livedocs.adobe.com/coldfusion/7/htmldocs/00001743.htm#1278307 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
