MySQL - loading image in BLOB Max. Download size?

Question

I use uploading files for images in BLOBs in the MySQL database, for some reason, when I upload some photos, I noticed that they were not fully displayed, then I tried to upload directly to PHPMyAdmin when it showed (Max: 64KiB) Fortunately, I started my own server, so I decided to check my php.ini for the maximum file upload size, it set the value to 250 MB. So my question is:

Where is the maximum file size for loading blob in mysql?

Answer 1

It depends on the type of column.

From the MySQL Documentation:, section Storage Requirements for String Types:

TINYBLOB

L + 1 byte, 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)