Rob, The Text, NText, and Image data types come from the previous versions of SQL Server. It is recommended that you use the newer varchar(MAX), nvarchar(MAX), and varbinary(MAX) data types instead.
Results to text only allows a maximum of 8192 characters. Perhaps this is also your issue in querying the database directly. [image: Screenshot] You could try using the TSQL len() function (not the CF len function) to find the length of the data and see if it has actually been truncated in the database, or just when you select it. On Mon, Mar 14, 2011 at 5:45 PM, Robert Harrison <rob...@austin-williams.com > wrote: > > Going straight to just the SQL update I have: > > <cfquery datasource="#dsn#"> > UPDATE tbl_capabilities_categories > SET capability_cat_txt2='HERE ARE 200,000 ALPHANUMERIC ONLY CHARACTERS' > WHERE id=#id#; > </cfquery> > > capability_cat_txt2 field type is TEXT > > Only about 63,000 of the update characters are being updated to the field. > The remainder is truncated. I am getting no truncation warning and I've > certainly makde sure there is no ' in the string to cause an early end to > the data. > > > Robert B. Harrison > Director of Interactive Services > Austin & Williams > 125 Kennedy Drive, Suite 100 > Hauppauge NY 11788 > P : 631.231.6600 Ext. 119 > F : 631.434.7022 > http://www.austin-williams.com > > Great advertising can't be either/or. It must be &. > > Plug in to our blog: A&W Unplugged > http://www.austin-williams.com/unplugged > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342999 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm