It depends on what kind of comparing you will be doing. Text is
case-Insensitive for comparisons, blob is case-Sensitive.
Generally I find that for pure text, TEXT type is better. For files and
texts that need to be compared case-sensitively, use BLOB.
Either way, for images, and any other bin
Is it wise to always assume that a file content is always binary and hence store it
in a MySQL BLOB type, even if the file may be only a text file? Your thoughts on
this would be appreciated.
sql
-
Before posting, please check
