mysql最大上传_MySQL-将图像上传到BLOB最大上传大小？

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??

解决方案

It depends on the type of your column.

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

TINYBLOB

L+1 bytes, where L < 28 (256 bytes)

BLOB

L+2 bytes, where L < 216 (65 kilobytes)

MEDIUMBLOB

L+3 bytes, where L < 224 (16 megabytes)

LONGBLOB

L+4 bytes, where L < 232 (4 gigabytes)