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
- 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 while 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.
- BLOB 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.
-
1Ah excellent! Thank you! - Arden Smith - 8 hours ago
Add a comment
