I'm an idiot. I restarted the server after making the change to 'Enable retrieval of long text'.
It works now. Boy is my face red. -- Jillian > -----Original Message----- > From: Jillian Carroll [mailto:[EMAIL PROTECTED] > Sent: May 30, 2003 12:39 PM > To: CF-Talk > Subject: RE: URGENT - MySQL Truncating DB Insert / Select > > > Yes, I've specified the field as LONGTEXT. > > This was leading me to believe that it's driver related... > but I can't see any way to fix it. > > -- > Jillian > > > -----Original Message----- > > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > > Sent: May 30, 2003 11:05 AM > > To: CF-Talk > > Subject: RE: URGENT - MySQL Truncating DB Insert / Select > > > > > > Did you specify TEXT as your column type? If so, that's > > limited to 65,535 characters. If you need more use > > MEDIUMTEXT (16,000,000 chars) or LONGTEXT (4,000,000,000 chars). > > > > > > > > --- > > Barney Boisvert, Senior Development Engineer > > AudienceCentral (formerly PIER System, Inc.) > > [EMAIL PROTECTED] voice : 360.756.8080 x12 > > fax : 360.647.5351 > > > www.audiencecentral.com > > > -----Original Message----- > > From: Jillian Carroll [mailto:[EMAIL PROTECTED] > > Sent: Friday, May 30, 2003 9:55 AM > > To: CF-Talk > > Subject: URGENT - MySQL Truncating DB Insert / Select > > > > > > I've recently moved my CF 5 server from RH Linux to Windows 2000... > > and now I'm having a problem with my MySQL database. I > can't insert > > or select more > > than about 65,000 characters (I've been doing character counts > > with spaces). > > > > I've selected 'Enable retrieval of long text' in the CF > administrator, > > but it isn't making any difference. > > > > If anybody can help me out... It would be much appreciated. I can't > > seem to find the answer in the forums, in Google... I'm stumped! > > > > Thanks!!!!!!! > > > > -- > > Jillian > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4