Im using CF Version 6.1 and am hitting an issue with retrieving data stored in an NTEXT field in SQL Server 2000.
The issue is that the entire value is being stored in the database, but upon retrieval its being truncated. When I check the Enable long text retrieval (CLOB) in CF Admin for my datasource it pulls the full value so I think this is my solultion. What I havent been able to find on the web is any downsides to checking this box. Are there any issues I should consider before I do check the Enable long text retrieval (CLOB) on my production server? Thanks! Tom ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
