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

by

TEXT and CHAR will convert to/from the character set they have associated with time. BLOB and BINARY simply store bytes.

BLOB is used for storing binary data while Text is used to store large string.

BLOB values are treated as binary strings (byte strings). They have no character set, and sorting and comparison are based on the numeric values of the bytes in column values.

TEXT values are treated as nonbinary strings (character strings). They have a character set, and values are sorted and compared based on the collation of the character set.

http://dev.mysql.com/doc/refman/5.0/en/blob.html

More Related Contents:

  1. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  2. 1052: Column ‘id’ in field list is ambiguous
  3. MySQL: Large VARCHAR vs. TEXT?
  4. How to do a batch insert in MySQL
  5. Count the occurrences of DISTINCT values
  6. Codeigniter – multiple database connections
  7. How can I store and retrieve images from a MySQL database using PHP?
  8. JOIN queries vs multiple queries
  9. Is the primary key automatically indexed in MySQL?
  10. What is the maximum length of data I can put in a BLOB column in MySQL?
  11. Storing Data in MySQL as JSON
  12. MySql: MyISAM vs. Inno DB! [closed]
  13. Difference between VARCHAR and TEXT in MySQL [duplicate]
  14. MySQL: Cloning a MySQL database on the same MySql instance
  15. DOs and DONTs for Indexes [closed]
  16. How to change the default port of mysql from 3306 to 3360
  17. How to insert images from database?
  18. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  19. When to use MyISAM and InnoDB? [duplicate]
  20. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  21. How to insert a file in MySQL database?
  22. Can’t import database through phpmyadmin file size too large
  23. What is the best way to do incremental backups in MySQL?
  24. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  25. MySQL: Check if the user exists and drop it
  26. How to store data with dynamic number of attributes in a database
  27. Is it unreasonable to assign a MySQL database to each user on my site?
  28. Create a new database with MySQL Workbench
  29. How to search and replace all instances of a string within a database?
  30. mySQL SELECT upcoming birthdays

Leave a Comment