Write a few significant differences between TEXT and BLOB

Posted by Jessica Taylor | Updated on

A BLOB is a large binary object that has the capability of holding a voluminous amount of data. There are a total of four types of BLOB in MySQL.

  • TINYBLOB
  • BLOB
  • MEDIUMBLOB
  • LONGBLO

BLOB and TEXT are different in terms of maximum length of values they can hold. TEXT is a BLOB that is case-sensitive in nature and divided into four categories. These are:

  • TINYTEXT
  • TEXT
  • MEDIUMTEXT
  • LONGTEXT

TEXT is usually case-sensitive, and BLOB are not case-sensitive for TEXT values.


If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.

Related Questions & Answers