can INSERT only handle so many characters?

[jacksonpt]

Is there a limit on how many characters can be pushed from a form to a MySQL db via INSERT?

I'm running into a strange behavior from my form, and it seems to be based on the number of characters submitted by a form.

[chyan]

it depend on what data type you using on your mysql

if you using char or varchar its limit to 255 character

The maximum size of a BLOB or TEXT object is determined by its type,
but the largest value you can actually transmit between the client and
server is determined by the amount of available memory and the size of
the communications buffers

[jacksonpt]

I don't think that's it... let me describe what's going on...

I'm working on a database that manages all of the majors offered at the university where I work. I have form that allows staff members to add majors to the database as necessary. The form deals with one record at a time, each text input represents one field in that record. The form handles 14 of the 15 fields for each record. One field is fairly large... up to a few hundred words (it's a description field). It is setup as TEXT in the DB. All other fields are pretty basic and setup as VARCHARs in the DB.

So here's what happens...
I fill out the form to add a record to the database. I clck submit and nothing happens. from here on out, I'm testing to find out what's wrong I clear the form, fill in the first field, click submit, record is added just fine. Same thing for the second field, third field, and so on.

Eventually I'll get far enough through the form so that when I fill in the text box and hit submit, nothing happens (same thing that happened when I filled out the form initially). So I clear that field, hit submit, and everything works fine again.

I enter 1 character in the field, hit submit, and it works. I do it again, this time with 2 characters, and everything works. Next time I do 3 characters... and so on.

Eventually I'll get to the point where adding the one additional character causes the form to stop working. The problem is, I'm not sure WHY it's not working.

Could the querystring only handle so many characters? When things don't work correctly, nothing is being sent to the querystring.

Does that help at all?

[chyan]

do you have a hidden field? like

<input type=hidden name=yourname value=$yourvalue>";

i'm predict your problem occur because of missing html tag

one thing you must remember when you working with a lot of field
dont missing a html tag, example:

<tr>
<input type=hidden name=yourname value=$yourvalue>";
</tr>

give the <tr> and </tr> tag beetwen your field

[laserlight]

Could the querystring only handle so many characters? When things don't work correctly, nothing is being sent to the querystring.

If I remember correctly, size of data passed using the GET method is pretty limited.
You might want to use the POST method instead, if the problem really does lie with using GET.

[wazo00]

IE only handles 2047 bytes in the address bar, this includes the URL.

Firefox handles about 5142 before the string disappears.