Hi, can anyone tell me why i can't input a page of text into my sql database using a form in dreamweaver. It seems to cut me off after a set amount. ive set the table columns to a blob and text with no luck and the form has no set limit as far as i am aware. Am i doing something completely wrong as iam new to php/mysql.

"If you assign a value to a BLOB or TEXT column that exceeds the column type's maximum length, the value is truncated to fit." a quote from the following web page:

dev.mysql.com/doc/mysql/en/BLOB.html

Perhaps this page will help.

Also, make sure your form method set to POST?

DMX | ASP | VBScript | ACCESS | SQL Server | IIS5

Edited by - sesame on 29 Oct 2004 13:22:37

Thanks, ive checked and the form is set to post. I read the suggested page but didn't quite understand it all. If i have set my field in my table to 'text' it should allow loads of text to be inserted, shouldn't it?. I haven't set the text area to a maximum length in my form. Your help is much appreciated.

try setting it to 'longtext' in the MySQL DB

Yup - janusz.co.uk