I had a similar issue with some long strings getting truncated using SQL Server and didn't seem to be able to get the long-text retreival checkbox to fix it... My solution at the time was to increase the text buffer size from 65000 to ... I think it's something like 900,000 that's the maximum... I don't remember offhand... accept that I think it was something like 1-5mb of data, so I figured I wasn't likely to have a text string longer than that.
> I've recently moved my CF 5 server from RH Linux to > Windows 2000... and now > I'm having a problem with my MySQL database. I can't > insert or select more > than about 65,000 characters (I've been doing character > counts with spaces). > I've selected 'Enable retrieval of long text' in the CF > administrator, but > it isn't making any difference. > If anybody can help me out... It would be much > appreciated. I can't seem to > find the answer in the forums, in Google... I'm stumped! > Thanks!!!!!!! > -- > Jillian > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/cf_lists/index. > cfm?method=subscribe&forumid=4 > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Signup for the Fusion Authority news alert and keep up > with the latest news in ColdFusion and related topics. > http://www.fusionauthority.com/signup.cfm > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey 972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
