Russ, the use of Varchar(MAX) negates that 8060 limit. SQL Server stores it differently.
That being said, Robert, are you sure that all the data is getting to your query? You say that they are doing extremely large entries, are you hitting the HTML Post limit? I believe that most web servers default the max size of a form post to 2 megabytes. Steve -----Original Message----- From: Russ Michaels [mailto:[email protected]] Sent: Tuesday, July 17, 2012 10:14 AM To: cf-talk Subject: Re: CF Long Text Truncation the row limit is 8060 bytes, are you sure your not exceeding this ? If you need to exceed this and store large amount of data thent hose fields will need to use TEXT or nTEXT data type which is not constained by the row limit as the data stored in these is treated as a BLOB, and the DB simply stores a pointer tot he data rather then the data itself in the table row. On Tue, Jul 17, 2012 at 2:49 PM, Robert Harrison <[email protected] > wrote: > > Discussed this once before, but my client has again exceeded the limits > and I'm not sure where the data is being truncated. I am using the > settings below. Any ideas what could be causing data truncation on long > (extremely long) strings? > > Data Base = MS SQL Server 2008 R2 > Data Field Length = Varchar(MAX) > Input field type = textarea > Insert Statement CFQUERY Param = <cfqueryparam > cfsqltype="CF_SQL_LONGVARCHAR" value="#trim(secured_text1) #"> > CF Data Source Advanced Settings = -- Enable long text retrieval > (CLOB) is Checked > > Two questions: > > 1. Is there any place else I should check that may have a setting > that's causing data truncation? > 2. Is it possible the CFQUERYPARAM type CF_SQL_LONGVARCHAR is > causing the truncation. I see I could also use cfsqltype="CF_SQL_CLOB", but > that does not seem to be supported on MS SQL Server. > > Any thoughts as to where the truncation may be occurring? > > Thanks > > Robert Harrison > Director of Interactive Services > > Austin & Williams > Advertising I Branding I Digital I Direct > 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 > T 631.231.6600 X 119 F 631.434.7022 > http://www.austin-williams.com > > Blog: http://www.austin-williams.com/blog > Twitter: http://www.twitter.com/austin_ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
