SyntaxFix

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

A BLOB can be 65535 bytes maximum. If you need more consider using a MEDIUMBLOB for 16777215 bytes or a LONGBLOB for 4294967295 bytes.

Hope, it will help you.

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to blob

• Angular: How to download a file from HttpClient? • How do we download a blob url video • How to convert Blob to File in JavaScript • Saving binary data as file using JavaScript from a browser • Inserting Image Into BLOB Oracle 10g • How to Display blob (.pdf) in an AngularJS app • Difference between CLOB and BLOB from DB2 and Oracle Perspective? • JavaScript blob filename without link • How to convert Blob to String and String to Blob in java • How to go from Blob to ArrayBuffer