MySQL TEXT vs BLOB vs CLOB

by

TEXT is a data-type for text based input. On the other hand, you have BLOB and CLOB which are more suitable for data storage (images, etc) due to their larger capacity limits (4GB for example).

As for the difference between BLOB and CLOB, I believe CLOB has character encoding associated with it, which implies it can be suited well for very large amounts of text.

BLOB and CLOB data can take a long time to retrieve, relative to how quick data from a TEXT field can be retrieved. So, use only what you need.

More Related Contents:

  1. How do you use MYSQL in ColdFusion? [closed]
  2. Using backticks around field names
  3. How do I do a bulk insert in mySQL using node.js
  4. Reorder / reset auto increment primary key
  5. Required to join 2 tables with their FKs in a 3rd table
  6. Does COUNT(*) always return a result?
  7. Save Data in Arabic in MySQL database
  8. Setting the MySQL root user password on OS X
  9. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  10. GROUP_CONCAT with limit
  11. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  12. SQL Query to show nearest date?
  13. How can I modify the size of column in a MySQL table?
  14. Return the nth record from MySQL query
  15. How to auto generate migrations with Sequelize CLI from Sequelize models?
  16. MySQL Fire Trigger for both Insert and Update
  17. Getting all parent rows in one SQL query
  18. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  19. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  20. MySQL view performance
  21. Does MySQL Regexp support Unicode matching
  22. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  23. How can I import a database with MySQL from terminal?
  24. Remove DEFINER clause from MySQL Dumps
  25. How to retrieve JSON data from MySQL?
  26. Is incrementing a field in MySQL atomic?
  27. Encryption at rest and/or AES_ENCRYPT
  28. MySQL: Compare BETWEEN time
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment