BLOB, TEXT, and case sensitivity: MySQL won’t treat them the same
When I first discovered that there is both BLOB and TEXT in databases, I was puzzled. They occupy the same amount of disk space, and the database doesn’t alter the data itself anyhow. Why two? Of course, I followed the stream, and went for TEXT and VARCHAR for everything, since I don’t store binary data [...]