Remarks 1) blob fields are used to store binary data in mysql. BLOB is a type series, including TinyBlob, BLOB, MediumBlob, and LongBlob, the only difference between these types is that the maximum size of the stored files is different. TinyBlob Max 255Blob Max 65 KMediumBlob
Remarks 1) blob fields are used to store binary data in mysql. BLOB is a type series, including TinyBlob, BLOB, MediumBlob, and LongBlob, the only difference between these types is that the maximum size of the stored files is different. TinyBlob Max. 255 Blob Max 65 K MediumBlob
Remarks on setting blob storage images in mysql
1) BLOB fields are used to store binary data.
In MySQL, BLOB is a type series, including TinyBlob, Blob, MediumBlob, and LongBlob. The only difference between these types is that the maximum size of the stored files varies.
TinyBlob Max. 255
Blob Max 65 K
MediumBlob up to 16 MB
Up to 4 GB LongBlob
2) MySQL max_allowed_packet settings
Show VARIABLES like '% max_allowed_packet % ';
Set global max_allowed_packet = 2*1024*1024*10;
After setting, exit the command line and log on again. It seems that the value of the system variable will be cached after logon.
Reference http://www.kuqin.com/database/20120622/320977.html
