What are the Size Limits for MySQL BLOB Columns?

MySQL BLOB Column Data Length Limits

MySQL BLOB columns are used to store binary data. The maximum size of data that can be stored in a BLOB column depends on the type of BLOB column:

• TINYBLOB: 255 bytes
• BLOB: 65,535 bytes (64 KB)
• MEDIUMBLOB: 16,777,215 bytes (16 MB)
• LONGBLOB: 4,294,967,295 bytes (4 GB)

Recommendation

For storing large amounts of data, consider using:

• MEDIUMBLOB for up to 16 MB of data.
• LONGBLOB for up to 4 GB of data.

Refer to the MySQL documentation on Storage Requirements for String Types for detailed information on data storage requirements in string types.

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