Maximum length for BLOB columns in MySQL

Well, that was interesting. I was debugging a problem with a particular uploaded document on Insightory, and it looks like I made the wrong decision when choosing the datatype for a blob column in one of my tables.

Apparently MEDIUMBLOB stores up to 16 MB of data, and the uploaded document was larger than that. Not a big deal, I’ll go ahead and accept blame and fix the table schema and move on.

However, when trying to research on this and find the maximum length for BLOB fields in MySQL at the manual, I get this pretty data table with some formulas on how to calculate the maximum number of bytes myself. Isn’t that helpful?

How about the members of the documentation team pre-calculate this stuff for me, so I can just read and absorb the content without taking out my calculator? Mmkay thx bye.

Leave a Comment