Home Whiteboard Practice Code Graphing Calculator Online Compilers Articles Tools
Tutorials Courses Jobs

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

MySQL MySQLi Database

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
 Overhead
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
Updated on: 2020-06-20T08:30:05+05:30

4K+ Views

Learn More in Our Tutorials

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements