Find the best answer to your question, help others answer theirs
If you are going to use a passage of Lorem Ipsum, you need to be sure there
isn't anything embarrassing hidden in the middle of text.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
1 Answer
A BLOB is a binary large object that can hold a variable amount of data. There are four types of BLOB –
- TINYBLOB
- BLOB
- MEDIUMBLOB
- LONGBLOB
They all differ only in the maximum length of the values they can hold.
A TEXT is a case-insensitive BLOB. The four TEXT types
- TINYTEXT
- TEXT
- MEDIUMTEXT
- LONGTEXT
They all correspond to the four BLOB types and have the same maximum lengths and storage requirements.
The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-sensitive for BLOB values and case-insensitive for TEXT values.
-
1Ah excellent! Thank you! - Arden Smith - 8 hours ago
Add a comment
