[Mediawiki-l] Error in numRows(): Illegal mix of collations

muyuubyou muyuubyou at gmail.com
Sat Feb 4 17:57:52 UTC 2006

When I try to create a Chinese or Japanese page I get this error:

 Error in numRows(): Illegal mix of collations (utf8_bin,IMPLICIT) and
(latin1_swedish_ci,COERCIBLE) for operation '='


   - GlobalFunctions.php line 451 calls wfbacktrace()
   - Database.php line 543 calls wfdebugdiebacktrace()
   - WatchedItem.php line 58 calls databasemysql::numrows()
   - User.php line 1098 calls watcheditem::iswatched()
   - Title.php line 891 calls user::iswatched()
   - SkinTemplate.php line 646 calls title::useriswatching()
   - SkinTemplate.php line 386 calls
   - OutputPage.php line 467 calls skinmonobook::outputpage()
   - OutputPage.php line 680 calls outputpage::output()
   - Database.php line 400 calls outputpage::databaseerror()
   - Database.php line 347 calls databasemysql::reportqueryerror()
   - Database.php line 723 calls databasemysql::query()
   - Database.php line 645 calls databasemysql::select()
   - LinkCache.php line 162 calls databasemysql::selectfield()
   - Title.php line 1150 calls linkcache::addlinkobj()
   - index.php line 86 calls title::getarticleid()

What can I do about it? I've checked my tables and they're utf8. I'm trying
to create a wiki about the Chinese language, so romanizing the titles is not
an option.


More information about the MediaWiki-l mailing list