{"id":93,"date":"2008-04-27T17:11:16","date_gmt":"2008-04-27T23:11:16","guid":{"rendered":"http:\/\/pessoal.org\/blog\/?p=93"},"modified":"2008-04-27T17:11:16","modified_gmt":"2008-04-27T23:11:16","slug":"maximum-length-for-blob-columns-in-mysql","status":"publish","type":"post","link":"https:\/\/pessoal.org\/blog\/2008\/04\/27\/maximum-length-for-blob-columns-in-mysql\/","title":{"rendered":"Maximum length for BLOB columns in MySQL"},"content":{"rendered":"<p>Well, that was interesting. I was debugging a problem with a particular uploaded document on <a href=\"http:\/\/www.insightory.com\">Insightory<\/a>, and it looks like I made the wrong decision when choosing the datatype for a blob column in one of my tables.<\/p>\n<p>Apparently MEDIUMBLOB stores up to 16 MB of data, and the uploaded document was larger than that. Not a big deal, I&#8217;ll go ahead and accept blame and fix the table schema and move on.<\/p>\n<p>However, when trying to research on this and <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/storage-requirements.html\">find the maximum length for BLOB fields in MySQL<\/a> at the manual, I get this pretty data table with some formulas on how to calculate the maximum number of bytes myself. Isn&#8217;t that helpful?<\/p>\n<p>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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23,18],"tags":[],"_links":{"self":[{"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/posts\/93"}],"collection":[{"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/comments?post=93"}],"version-history":[{"count":0,"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/posts\/93\/revisions"}],"wp:attachment":[{"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/media?parent=93"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/categories?post=93"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/tags?post=93"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}