I have created a web site which gets numerous details of the user using ASP. I have created a suitable database using VFP6.0 and everything seemed to be OK. I have since tested thoroughly and have noticed that whenever I write any details to the database the insert-sql statement doesn't work when one of the strings I am appending into the database is quite long. The thing is the field that this long string is being inserted into is a memo field and I thought these were pretty large.

The string in question is about 100 characters long.

Is it the sql statement that is limited in size or is the mem field the culprit, can someone help?