What is blob and what is text? What are the differences?
When do I need to use blob and when do I need text as data type?
Because for blob and text, there are mediumblob == mediumtext, smallblob == small text. Do they even have the same meaning?
And look at this MEDIUMBLOB, MEDIUMTEXT L + 3 bytes, where L < 224.
What is L?
According to High-performance Mysql book:
The only difference between the BLOB and TEXT families is that BLOB types store binary data with no collation or character set, but TEXT types have a character set and collation.
BLOB stores binary data which are more than 2 GB. Max size for BLOB is 4 GB. Binary data means unstructured data i.e images audio files vedio files digital signature
Text is used to store large string.
