yes certainly something you need to remember. Every argument you have on a list gets Googled and will show up in search results :-) Even twitter posts get Googled.
On Mon, Mar 14, 2011 at 10:58 PM, Bobby Hartsfield <[email protected]>wrote: > > Even the ones** > > > .:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > http://cf4em.com > > -----Original Message----- > From: Bobby Hartsfield [mailto:[email protected]] > Sent: Monday, March 14, 2011 5:41 PM > To: cf-talk > Subject: RE: Data Truncation on TEXT field > > > 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:[email protected]] > 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:343032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
