What is the difference between longblob and longtext in mysql?

Question

What is difference between longblob and longtext in mysql?

What should I use to save a long topic ?

Answer 1

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.

Answer 2

BLOB and TEXT are basically identical, except that TEXT fields have character set translation rules applied. BLOB fields do not. So with BLOB what you put in is what you get. With TEXT, what you put may not be what you get out.