WordPress 2.9 Illegal Mix of Collations in Database

In the course of investigating a problem with runaway Apache processes, I discovered this collation issue.

In the apache error log, the first error to confront me was this:

 WordPress database error Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' for query SELECT comment_ID FROM wp_comments WHERE comment_post_ID = '2933' AND comment_approved != 'trash' AND  .... etc

Continue reading