I have a consistency problem with php and mysql. I have a table in the database with a text column. I use a form to pass text to the database, but it doesn't accept entries if they are over a certain length. Other times, it won't accept shorter entries. Are there restrictions on text fields, or is it the database? Someone help! Send replies to firstname.lastname@example.org. Thanks.
Comments on this post
It might not be the length at all, but the fact that there are quotes in the string.
use the php function addslashes() on your string before putting it in the DB and see what happens.
PHP, Perl, SQL Programming at http://www.mentalobjects.com