What type of column should I use to store long blocks of text?
I'm using DataAssist to create an advanced text search form that will allow my website visitors to search for articles that have been published on my site. I'd like to give my website visitors the ability to search the entire text of an article if possible.
But each time that I use a column in my database to store the text of an article (I've used LongText and LongBlob data types), I get an error message on the search results page saying that I have a MySQL syntax error near the text column.
I realize this is a PHP/MySQL question, rather than a DataAssist question, but I've gotten so much great help on this forum that I figured I'd try asking this. My question is, which MySQL data type is best for storing a large amount of text; what if any settings should I apply to that data column; and can I paste text into the column from a Word or Notepad file?