- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 | 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 |
Advertisements