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

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

2

Best Answer

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.

May or may not be accurate, but according to this site: http://www.htmlite.com/mysql003.php.

BLOB A string with a maximum length of 65535 characters.

The MySQL manual says:

The maximum size of a BLOB or TEXTobject is determined by its type, butthe largest value you actually cantransmit between the client and serveris determined by the amount ofavailable memory and the size of thecommunications buffers

I think the first site gets their answers from interpreting the MySQL manual, per http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

Random Posts

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, object given [duplicate]How to use --create-application=false with ng new commandcan't create and generate typeorm migrationggplot2 multiple sub groups of a bar chartJSON Structure for List of ObjectsHow do I delete Columns from a table if not another table using SQL?Are most of the ASCII control characters obsolete?Why is Cobra flags not working in this codeHow to test sh script return status with jenkins declarative pipeline new syntaxNetsuite USAGE_LIMIT_EXCEEDED error on suiteletusing the parameters in Alteryx workflowsHow to make QR Code in crystal reports Visual StudioAZ module seems to keep breaking in powershell with a message about import-moduleHow to resolve cURL Error (7): couldn't connect to host?Google Chrome is zoomed inWhat does @-moz-document url-prefix() do?How would I change a voice channel's bitrate using discord.py?I need a sunrise/sunset webservice api [closed]oracle - what statements need to be committed?What does the argument mean in fig.add_subplot(111)?