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

As we know that BLOB is a binary large object that can hold a variable amount of data. The different TEXT objects offer a range of storage space from 255 bytes to 4 Gb. Following table shows the storage of different kinds of BLOB data type −

Type of BLOB
Maximum amount of Data that can be stored
Up to 255 bytes
1 byte
Up to 64 Kb
2 bytes
Up to 16 Mb
3 bytes
Up to 4 Gb
1 Bytes

Updated on: 20-Jun-2020

3K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started