Comments - BLOB and TEXT Data Types
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
is BLOB data compressed before storage? The file size i store is very much larger than the whole table size. How is this possible?
Blob or text are not compressed by default. You can however add the COMPRESSED option to the column when you create or alter the table
They can be, see for example the InnoDB COMPRESSED Row Format.