ah yes Varchar (max) is the new TEXT On Tue, Jul 17, 2012 at 3:20 PM, DURETTE, STEVEN J <[email protected]> wrote:
> > 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:351914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
