I noticed that I'm using a mixed set of UTF-8 and ISO-8859-1 on my site.. the database is in UTF-8, collation in Latin1, and the data being stored is ISO-8859-1.

As I'm straightening it out (converting everything to UTF-8), I'd need to know names for all the tables that contain binary data so that I can extract them from the database separately. Text data gets converted with iconv while the binary data obviously should remain untouched. Conversion advice at couple of sites includes mysqldump examples with partial table lists (for example, both of them omit table "attachment"). Perhaps someone here would have a complete/up-to-date list?