What's the Maximum Data Size for MySQL BLOB Columns?

Maximum Length of Data in MySQL BLOB Columns

In MySQL, BLOB (Binary Large OBject) columns provide storage for large binary data. However, there is a limit to the amount of data that can be stored in a BLOB column.

Question:

What is the maximum length of data that can be stored in a BLOB column in MySQL?

Answer:

The maximum length of data that can be stored in a BLOB column in MySQL is 65535 bytes (64 KB).

If you need to store larger amounts of data, MySQL offers two additional options:

• MEDIUMBLOB: Allows for up to 16777215 bytes (16 MB) of data.
• LONGBLOB: Supports up to 4294967295 bytes (4 GB) of data.

For more information on storage requirements for string types, please refer to the official MySQL documentation: https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html

The above is the detailed content of What's the Maximum Data Size for MySQL BLOB Columns?. For more information, please follow other related articles on the PHP Chinese website!