What are the size limits for BLOB, MEDIUMBLOB, and LONGBLOB data types in MySQL?

MySQL BLOB Column Data Length Limits

The maximum data length that can be stored in a BLOB (Binary Large OBject) column in MySQL is 65535 bytes, equivalent to 64 KB. This length applies to the BLOB data before compression, as MySQL compresses BLOB data by default.

If you require storing larger data volumes, consider using these extended data types:

• MEDIUMBLOB: Can hold up to 16777215 bytes (16 MB) of data.
• LONGBLOB: Suitable for storing data up to 4294967295 bytes (4 GB).

For further details on storage requirements for string types in MySQL, consult the "Storage Requirements for String Types" documentation.

The above is the detailed content of What are the size limits for BLOB, MEDIUMBLOB, and LONGBLOB data types in MySQL?. For more information, please follow other related articles on the PHP Chinese website!