What is the maximum length of data I can put in a BLOB column in MySQL?

mysql blob
Newy picture Newy · Apr 25, 2011 · Viewed 180.5k times · Source

What is the maximum length of data I can put in a BLOB column in MySQL?

Answer

WhiteFang34 picture WhiteFang34 · Apr 25, 2011

A BLOB can be 65535 bytes (64 KB) maximum.

If you need more consider using:

  • a MEDIUMBLOB for 16777215 bytes (16 MB)

  • a LONGBLOB for 4294967295 bytes (4 GB).

See Storage Requirements for String Types for more info.

Related questions

How can I store and retrieve images from a MySQL database using PHP?

How can I insert an image in MySQL and then retrieve it using PHP? I have limited experience in either area, and I could use a little code to get me started in figuring this out.

Read More
How to insert image in mysql database(table)?

I want to insert image into a table like CREATE TABLE XX_SAMPLE(ID INT ,IMAGE BLOB); So can you help out form how to insert image into the above table.

Read More
What are the differences between the BLOB and TEXT datatypes in MySQL?

What is blob and what is text? What are the differences? When do I need to use blob and when do I need text as data type? Because for blob and text, there are mediumblob == mediumtext, smallblob == small text. Do …

Read More