String data type
The string data type is the most commonly used data type. Thanks to this, both text and various binary data (for example, pictures) are stored in the database.
In MySQL, it is represented by the following types:
CHAR and VARCHAR
BINARY and VARBINARY
The BINARY and VARBINARY data types are similar to VARCHAR and CHAR except that they store binary strings.
BLOB and TEXT
BLOB is used to store large binary data such as pictures. TEXT is also for storing big data, but textual content.
The difference between them is that the sorts and comparisons of stored data for BLOB are case sensitive and not case sensitive in TEXT fields.
BLOB and TEXT have additional subtypes that differ in the maximum data size that can be stored in them.