Changing Data and Structure - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 107

There are chances that this is not our favorite image editor! In fact, data may be
corrupted even if we save this row without touching the BLOB column type. But the
possibility of setting $cfg['ProtectBinary'] to FALSE exists, as some users put
text in their BLOB columns, and they need to be able to modify this text. This is why
phpMyAdmin can be configured to allow editing of BLOB columns.
MySQL BLOB data types are actually similar to their corresponding TEXT data
types. However, we should keep in mind that a BLOB has no character set, whereas
a TEXT column type has a character set that impacts sorting and comparison.
ENUM and SET column types
Both ENUM and SET column types are intended to represent a list of possible values.
The difference is that the user can choose only one value from a defined list of values
with ENUM , and more than one value with SET . With SET , all the multiple values
go into one cell; but multiple values do not imply the creation of more than one row
of data.
We add a column named genre to the topic table and define it as an ENUM . For
now, we choose to put short codes in the value list and make one of them, F , into the
default value as shown in the following screenshot: