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