We have a database that uses MS SQL text fields. Is this what the CLOB in CF is for? What is the difference between CLOB and Long Text Buffer in the datasource settings page?
The problem is we've had clients complain that the amount of text retrieved is not big enough, and I've had to bump up the Long Text Buffer several times. Its at 96000 now, and I was wondering what ramifications this has on performance and whether I should just enable CLOB instead. Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208061 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