Re: Issues with long SQL inserts
| From: | Chris Snyder | Date: | Sun, 31 Mar 2002 23:06:04 +0000 |
| Subject: | Re: Issues with long SQL inserts | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-90911@lists.php.net to get a copy of this message | ||
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.