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 −

Giri Raju

Published on 20-Feb-2018 05:40:09

• Related Questions & Answers
• What is the maximum length of data we can put in a TEXT column in MySQL?
• What is the maximum length of MySQL VARCHAR column?
• What is BLOB data type in MySQL?
• How can we put comments in a column of existing MySQL table?
• What is the maximum length of a table name in MySQL?
• What is the maximum length of each type of identifier in MySQL?
• MySQL query to fetch column length declared with BLOB type
• How can we change the data type of the column in MySQL table?
• What is the maximum length of string in Python?
• How can we retrieve the length of a specified string in MySQL?
• How can we amend the declared size of a column’s data type in MySQL?
• How can we put schedule for different kinds of MySQL events?
• What is the maximum file size we can open using Python?
• Can we GROUP BY one column and select all data in MySQL?
• Maximum Column name length in SAP HANA