Re: form post getting cut off at 32,000

2009-02-12 Thread Jason Fisher
A bit OT, but I would strongly recommend NOT changing to "text". If you ever have an entry expecting a Unicode character outside of the low/high ASCII (0-255 character entries), text will foobar it for you but ntext will handle correctly.

RE: form post getting cut off at 32,000

2009-02-12 Thread Mik Muller
Thanks, >Mike > >-----Original Message- >From: Mik Muller [mailto:ad...@montaguema.net] >Sent: Thursday, February 12, 2009 2:08 PM >To: cf-talk >Subject: Re: form post getting cut off at 32,000 > > >Yes, that was it. I had Long Text Buffer (chr) set to 64000 and

RE: form post getting cut off at 32,000

2009-02-12 Thread Dawson, Michael
Sure, it's scriptable. Google "sql alter table" and the particular platform of DB you are using. Thanks, Mike -Original Message- From: Mik Muller [mailto:ad...@montaguema.net] Sent: Thursday, February 12, 2009 2:08 PM To: cf-talk Subject: Re: form post getting cut off

Re: form post getting cut off at 32,000

2009-02-12 Thread Mik Muller
Yes, that was it. I had Long Text Buffer (chr) set to 64000 and the CLOB checkbox off. I suppose that the field being "ntext" cut the 64000 in half to 32000. Perhaps I should change the field to just "text". Now to update a few dozen databases. Sigh. Anyone know how to script that kind of c

Re: form post getting cut off at 32,000

2009-02-12 Thread Matthew Williams
Yeah... this just bit me too. You need to adjust either your clob/blob size for the DSN. The default cuts off at 32k. Even if the clob/blob options are not checked, that seems to be the cutoff. I'm reasonably sure that clob is the one you're looking to change. Matthew Williams Geodesic Gr

Re: form post getting cut off at 32,000

2009-02-12 Thread Azadi Saryev
what's the setting for Long Text Buffer in Advanced Settings for your dsn in cf admin? do you have clob/blob retrieval enabled there as well? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mik Muller wrote: > Hey all, > > Bizarre. I have a message board application and a new user is post

Re: form post getting cut off at 32,000

2009-02-12 Thread Barney Boisvert
My guess is you need to go change the buffer size in the DSN settings in the CF Admin. cheers, barneyb On Thu, Feb 12, 2009 at 11:07 AM, Mik Muller wrote: > > Hey all, > > Bizarre. I have a message board application and a new user is posting 130,000 > character long newsletter-like posts that

form post getting cut off at 32,000

2009-02-12 Thread Mik Muller
Hey all, Bizarre. I have a message board application and a new user is posting 130,000 character long newsletter-like posts that are getting cut off at 31,999 characters in the database, but not in the email that is sent after the sql insert. o There are only two text fields being posted in