php - MySQL - Uploading Image To BLOB Max Upload Size?

Question

I'm using file uploading for images into a BLOB in a MySQL database, for some reason when I upload some pictures I noticed they weren't completely rendered, I then tried uploading directly into PHPMyAdmin when it then showed (Max: 64KiB) I luckily enough run my own server so I thought to go check my php.ini for max file upload size, it's set to 250MB. So my question is,

Where is the max filesize for MySQL BLOB Uploads??

Answer 1

It depends on the type of your column.

From MySQL documentation:, section Storage Requirements for String Types:

TINYBLOB

L+1 bytes, where L < 2⁸ (256 bytes)

BLOB

L+2 bytes, where L < 2¹⁶ (65 kilobytes)

MEDIUMBLOB

L+3 bytes, where L < 2²⁴ (16 megabytes)

LONGBLOB

L+4 bytes, where L < 2³² (4 gigabytes)