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

by

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.

More Related Contents:

  1. Store image to database blob; retrieve from db into Picturebox
  2. What are the differences between the BLOB and TEXT datatypes in MySQL?
  3. What is difference between storing data in a blob, vs. storing a pointer to a file?
  4. When is using MySQL BLOB recommended?
  5. SELECTING with multiple WHERE conditions on same column
  6. grant remote access of MySQL database from any IP address
  7. Should MySQL have its timezone set to UTC?
  8. JDBC batch insert performance
  9. SQL – Update multiple records in one query
  10. How to find gaps in sequential numbering in mysql?
  11. Can I create view with parameter in MySQL?
  12. MySQL: Invalid use of group function
  13. How to get only Digits from String in mysql?
  14. auto increment primary leaving gaps in counting
  15. Exporting results of a Mysql query to excel?
  16. OUTPUT Clause in MySQL
  17. Relationship between catalog, schema, user, and database instance
  18. Sorting by date & time in descending order?
  19. passing LIMIT as parameters to MySQL sproc
  20. Case statement in MySQL
  21. MySQL ‘UPDATE ON DUPLICATE KEY’ without a unique column?
  22. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  23. Import MySQL dump to PostgreSQL database
  24. How to select data where a field has a min value in MySQL?
  25. Database corruption with MariaDB : Table doesn’t exist in engine
  26. How to SELECT by MAX(date)?
  27. MYSQL declaring variables
  28. get a recursive parent list
  29. MYSQL – Split Data Into Multiple Rows
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment