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
