Sorry, I've reached the end of my tech-support flow-chart. You might want to try 2 things:
1: Fire up the MySQL client of choice and do the insert manually. If it works there. If it does then at least you've isolated the problem to PHP or your script. If not then you've eliminated your script and PHP form the list. 2: post the question, along with the results from the above experiment and any other relevant information to the mysql list. (www.mysql.com if you are not a member, there;s info on joining there) My guess is that it's a MySQL problem and there are people there who could help you better than I. Sorry I wasn't more help, =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -----Original Message----- From: Chris Snyder [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 31, 2002 5:06 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Issues with long SQL inserts Cal Evans wrote: >I'm not up on the exact spec on MySQL but if it has an 'unlimited' text type >then it is a rarity among SQL engines. M$SQL's limit is (used to be?) 8MB >in a single text field. > >FoxPro/dBase had an unlimited text field but that's not so must a SQL engine >as a file format. > >My guess is that you are banging your head against the upper limit. I did >notice that it has a BIGTEXT type. Maybe try that. It still won't solve >the problem but it may give you more room. > Well, not strictly unlimited, but it basically is for my purpose - according to the manual, it's 65535 chars - I'm at around 8000-9000 right now, much lower than the limit. I tried going to mediumtext - limit of 16777215, and it acts the same. Both are quite a bit above what I'm trying to do. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
