What is the maximum length of data I can put in a BLOB column in MySQL?

What is the maximum length of data I can put in a BLOB column in MySQL?

 Answers

A BLOB can be 65535 bytes (64 KB) maximum.

If you need more consider using:

• a MEDIUMBLOB for 16777215 bytes (16 MB)
• a LONGBLOB for 4294967295 bytes (4 GB).

See Storage Requirements for String Types for more info.

---

A binary large object that can hold a variable amount of binary data. The sorting and comparison of the values for these objects is performed in case-sensitive manner.

TINYBLOB

A binary large object column with a maximum length of 255 (2^8 - 1) characters.

BLOB

A binary large object column with a maximum length of 65535 (2^16 - 1) characters.

MEDIUMBLOB

A binary large object column with a maximum length of 16777215 (2^24 - 1) characters.

LONGBLOB

A binary large object column with a maximum length of 4294967295 (2^32 - 1) characters.