This article will guide you on how #MySQL #BLOB data type works in storing and displaying images with #PHP on Ubuntu 18.04. A BLOB is a binary large object that can hold a variable amount of data.
A Binary Large OBject (BLOB) is a collection of #binary data stored as a single entity in a database management system. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob.
The four BLOB types are #TINYBLOB , #BLOB , #MEDIUMBLOB , and #LONGBLOB . These differ only in the maximum length of the values they can hold. The four TEXT types are TINYTEXT , TEXT , MEDIUMTEXT , and LONGTEXT .
The size of blob in MySQL:
TINYBLOB - Up to 255 bytes - 1 byte
BLOB - Up to 64 Kb - 2 bytes
MEDIUMBLOB - Up to 16 Mb - 3 bytes
LONGBLOB - Up to 4 Gb - 1 Bytes