I forgot that I've seen this before, but I had a client trying to enter text (quite a bit, in fact) and it kept failing. After finally getting all of the information on the incident, it turns out that the following error was being generated:
I google'd around a bit before I found the answer. We're storing the body field as a CLOB (at least, I'm pretty sure that's what it is). The default buffer size for this in the ColdFusion administrator is 32k. My text input went beyond that. Whoops. So, I made sure to check the box for CLOB (and turned on BLOB for good measure) and set the size to 128k. Problem solved, and now they can enter a very long string of text into the database. Just throwing this out there in case anyone else stumbles upon this issue.
and these large text fields in the database usually don't know how to store high ascii. What i've usually
been forced to do is alter the field at the database level to an ntext format while also insuring that the
site enforces UTF-8 or a similar Unicode setting for text content throughout the site.
Wish these database companies would catch up with the 21st century and create a content type that allows for
easy storage of large amounts of high ascii text. It only makes sense when the world is going to rich content.