Enable Blob/Clob on the datasoruce. FYI, this is a public list indexed by Google... Client's can search for your name... if the ones with no sense haha ;-)
.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -----Original Message----- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Monday, March 14, 2011 1:39 PM To: cf-talk Subject: Data Truncation on TEXT field Hi, I have a client with no sense who want to type a book into a single field. They have over 200,000 characters they are typing into the edit file. Data base is: MS SQL 2008 R2 Field type is: text When an update is done the data is truncated at around 63,000 characters. I've output that data before update the update can see that all the data is being passed to the next page. I also tried hardcoding the data into the SQL statement to see if it gets truncated and it still does. With a data type of TEXT I can see no reason truncation is occurring. Anyone have any ideas on this? Thanks 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:343009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
