The field type is ‘TEXT’. I know the ‘TEXT’ field can hold the data. I have had it inserted in there using phpMyAdmin. But it was when I was attempting to find the character limit at the truncation point is when I found I could insert much more data if it were just numbers, letters and spaces. So this lead me to finding a character that was causing this in the form. So every time I hit words like (we’ll or that’s) the apostrophe clued me in.
So how to deal with that in the PHP code is going to be a new lesson for me.
If you do have advice or know of an article on that I would welcome it, but also at this point I am thankful for your input that led me to this point! Later tonight I’ll hit this again!
Sounds like you’re probably interpolating the content of the input field directly into your SQL query. That’s dangerous — don’t do it. Here’s a quick rundown on how to effectively use PDO and parameterized queries to avoid this problem: