For the former problem, I wrote a script that you could call periodically to warn you of potential problems with your views. Now I’ve extended it to warn you about collation issues as well.
ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,EXPLICIT) and (utf8_unicode_ci,EXPLICIT) for operation '='
P.S. I’ve found that the option
the MySQL config works better than
default-character-set = utf8
because the lack of a
default-collation-connection option can get you
utf8_general_ci autoselected instead.