CODEWITHSUNDEEP
mysqlsqltypes
domlao
domlao

Reputation: 16029

Datatype of image data in MySQL

I want to store my image data into my MySQL database or table. What appropriate data type in MySQL should I use to store the image data?

Upvotes: 2

Views: 11789

Answers (1)

Hck
Hck

Reputation: 9167

You can use one of this field types:

BLOB        L + 2 bytes, where L < 2^16
MEDIUMBLOB  L + 3 bytes, where L < 2^24
LONGBLOB    L + 4 bytes, where L < 2^32

Upvotes: 8

Related Questions