What is the difference between longblob and longtext in mysql?

php mysql types long-integer sqldatatypes
faressoft picture faressoft · Apr 5, 2011 · Viewed 18.9k times · Source

What is difference between longblob and longtext in mysql?

What should I use to save a long topic ?

Answer

evilone picture evilone · Apr 5, 2011

BLOBs are for Binary Large Objects. If you're storing binary data in your DB, then BLOB would be the table type you want. Otherwise.. longtext.

In your case longtext.

Related questions

MySQL integer field is returned as string in PHP

I have a table field in a MySQL database: userid INT(11) So I am calling it to my page with this query: "SELECT userid FROM DB WHERE name='john'" Then for handling the result I do: $row=$result->fetch_…

Read More
Which MySQL datatype to use for an IP address?

Possible Duplicate: How to store an IP in mySQL I want to get the IP address from $_SERVER['REMOTE_ADDR'] and some other $_SERVER variables, which datatype is the right one for this? Is it VARCHAR(n)?

Read More
PDO::PARAM for dates?

Does some PDO::PARAM_??? exist which can be used for dates or timestamps? Sample code: $sql = "UPDATE my_table SET current_date = :date WHERE id = 43"; $statement = $pdo->prepare ($sql); $statement->bindParam (":date", strtotime (date ("Y-m-d H:i:s")), …

Read More