RE: [PHP] Issues with long SQL inserts

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. HTH, =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -----Original Message----- From: Chris Snyder [mailto:csnyder@mvpsoft.com] Sent: Sunday, March 31, 2002 4:45 PM To: cal@calevans.com Cc: php-general@lists.php.net Subject: Re: [PHP] Issues with long SQL inserts Cal Evans wrote: >Have you tried shaving the article off a couple of chrs before the last one >and seeing if the insert works? Also, what is the size limit on a MySQL TEXT >field? > >http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BL O >B > Thanks for the quick response. I looked at the MySQL doc, and it didn't seem to offer any explanation. The column type is text, with no limit, which theoretically should give me around 8 meg - I'm getting around 8-9K.<g> The docs say that memory might be a problem, but the server has 512 meg, with 40 meg free, and around 450 meg of swap - shouldn't be a problem. >-----Original Message----- >From: Chris Snyder [mailto:csnyder@mvpsoft.com] >Sent: Sunday, March 31, 2002 3:43 PM >To: php-general@lists.php.net >Subject: [PHP] Issues with long SQL inserts > > >Server is running PHP 4.1.2, APC 1.1.0pl1, MySQL 3.23.47, Apache 1.3.23 >on a built-from-scratch Linux system with kernel 2.4.17, glibc 2.2.5, >and gcc 3.0.4. > >I'm using a fairly simple script to take input from a form, and add it >to a database. The database has the following structure: >ID - mediumint(8), primary key, auto_increment >Added - date >Modified - timestamp(8) >Title - varchar(60) >Text - text > >What's happening is whenever I try to add an article that has text with >a size of over around 9 KB, the browser never finishes loading, and the >article doesn't appear in the list. When I hit the stop button on the >browser, the article will then appear in the article list, but >incomplete - it is always cut off at the same spot. > >This sounds like some kind of buffer issue, but I've looked through all >of the applicable settings that I could find in both my PHP and MySQL >configuration files, and have found nothing. Any ideas? Thanks in >advance. To see the source code for this script, go to >http://test.mvpsoft.com/add.txt . Thanks in advance for any >help! > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > >