What is the best type to use for a big paragraph of text like 1000+ words? I tried to use 'text' type but it kept on not entering the data when it was about 20 words. It only accepted like 5 or so words. Why is this and is there a better type I can use for this function? Thanks.
text type holds up to 64kb of data.It should work for almost all your needs. Where are you viewing the field? in phpmyadmin? or is it being outputted by a php script?
Yes, I'm viewing the field in PHPmyadmin. The form gets submited to PHP which enters the data into the database. I really don't understand why it won't work because if I only type 2 words it enters the data into the database fine, but if I enter a short paragraph like I want, it goes through the entire PHP script giving no error; but the data (including about 8 other data fields) doesn't appear in my database. Plz help!
It works from PHPadmin but not when I use my PHP script to enter data. So... are there any other datatypes I can use?