Illegal mix of collations

Issue Summary

I submitted a new "issue" since it's slightly different than the other "Illegal mix of collations" issue.

Below is the error I get when trying to bulk generate aliases for nodes, users and taxonomy terms that are not aliased.

I'm using a fresh install of Drupal 6.4. The only modules I have installed are Token and Pathauto. The MySQL database, tables and fields are set to "utf8_unicode_ci". I have not edited these collations myself.

"* user warning: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' query: SELECT n.nid, n.vid, n.type, n.title, n.uid, n.created, n.language, alias.src, alias.dst FROM node n LEFT JOIN url_alias alias ON CONCAT('node/', CAST(n.nid AS CHAR)) = alias.src WHERE alias.src IS NULL AND n.type IN ('page','story') LIMIT 0, 50 in" ... "/public_html/drupal/modules/pathauto/pathauto_node.inc on line 101."

"* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 0, 50' at line 1 query: SELECT tid, vid, name, src, dst FROM term_data LEFT JOIN url_alias ON CONCAT('taxonomy/term/', CAST(tid AS CHAR)) = src WHERE src IS NULL AND vid <> 0 ) LIMIT 0, 50 in" ... "/public_html/drupal/modules/pathauto/pathauto_taxonomy.inc on line 84."

"* user warning: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' query: SELECT uid, name, src, dst FROM users LEFT JOIN url_alias ON CONCAT('user/', CAST(uid AS CHAR)) = src WHERE uid > 0 AND src IS NULL LIMIT 0, 50 in" ... "/public_html/drupal/modules/pathauto/pathauto_user.inc on line 95."