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:351912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
