How to store a blob (image) in MySQL?

Question

I am using php and intervention

What is the db format of a blob?

Is MySQL saving it as base64?

Before I save an image file to db what should I do?

Image::make('......')->encode('data-url');

Is that it?

blob stands for "Binary Large OBject". The data inserted should be binary, such as an image, not base64 encoded. You could use base64 to encode data while in transit, but it should be decoded when stored in a blob field. — Jonathan Kuhn
– Jonathan Kuhn, Commented Nov 2, 2016 at 22:33
@JonathanKuhn so if I provide a File parameter for the column it is OK? — Jocky Doe
– Jocky Doe, Commented Nov 2, 2016 at 22:35

Community · Accepted Answer · 2017-05-23 10:30:13Z

How to store a Binary Large Object (BLOB)?

A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types are TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB.
These differ only in the maximum length of the values they can hold.
The four TEXT types are TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. These correspond to the four BLOB types and have the same maximum lengths and storage requirements.

Hope the following code will help you:

CREATE TABLE IMAGE_TABLE(
    IMG_ID INT(6) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    IMG_DETAILS CHAR(50),
    IMG_DATA LONGBLOB,
    IMG_NAME CHAR(50),
    IMG_SIZE CHAR(50),
    IMG_TYPE CHAR(50)
);

This will create a table which will suit your requirement.

You may also refer the following SO answers:

You can refer the official documentation here. This link and this link would be worth a read to deepen your understanding.

Collectives™ on Stack Overflow

How to store a blob (image) in MySQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related