919 - 926 - 9847

Error when entering lots of text view the body tag of a FarCry content item

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:


ErrorContext WDDX packet parse error at line 1, column 32001.
Message WDDX packet parse error at line 1, column 32001. XML
document structures must start and end within the same entity..
StackTrace coldfusion.wddx.WddxDeserializationException: WDDX
packet parse error at line 1, column 32001. XML document
structures must start and end within the same entity

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.

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
CfAlchemist's Gravatar Will this properly store high ASCII characters? I've run into this issue before on some other projects
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.
# Posted By CfAlchemist | 2/4/09 1:27 AM