I found the issue and it wasn't SQL. ColdFusion has a max long text buffer of 64k. This limits 32k worth of characters to be passed through CF to a text field. I just doubled the size and it works ok.
>>>I'm storing a large chunk of text into a text field and I just found out >that the text is being truncated. > >Just to eliminate the more obvious: >Of course, you have already verified the maximum length of the text field? > >-- >_______________________________________ >REUSE CODE! Use custom tags; >See http://www.contentbox.com/claude/customtags/tagstore.cfm >(Please send any spam to this address: [EMAIL PROTECTED]) >Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3108 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
