Storing text in DB
What type of data is best to use to store text in my database? Text, Blob, something else? It could be everything from one sentence to 10 or more..I've used "text" so far because it just seemed like the obvious choice. But now that I've tried to extract the data from the DB, all the "varchar" columns was no problem at all, but I've got NOTHING from the "text" column. Is there anything speciell you need to do with text when you wanna get the data? The array slot seems to be empty when I try to look at it in PHP..
while ($arrPerson = mysql_fetch_array($result) {
this works fine (varchar)--> $name = $arrPerson["name"]
here I get an empty var(text)--> $comment = $arrPerson["comment"]
^that isn't my actual code so syntax errors are probably not there in the real one, in case you find any..