How to show mySQL BLOB data
If you need to peek, say into user-­­­>data, which is seralised data array, just use drush sqlc to bring yourself to an sql command line, then type:

 select uid, name data from users where uid = &lt;whateveruidyouwant&gt;;


This works for any data, and if you are brave you can even edit the serialized data via command-line but is not recommended unless you know what you are doing.