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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
