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

Giri Raju

Published on 20-Feb-2018 10:10:09

Previous Page Print Page