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.
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:
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.