[Mediawiki-l] MySQL collation for the mediawiki tables

[Darren VanBuren]

I attempted to install Bugzilla in the same database as mediawiki  
(Kinda stupid i know).

Bugzilla messed with the collations (it wants them UTF-8).

Now, when I attempt to go to Special:Recentchanges while logged in, I  
get this:

Database error
A database query syntax error has occurred. This may indicate a bug in  
the software. The last attempted database query was:

     (SQL query hidden)

from within function "wfSpecialRecentchanges". MySQL returned error  
"1267: Illegal mix of collations (latin1_bin,IMPLICIT) and  
(utf8_general_ci,IMPLICIT) for operation '=' (mysql3.freehostia.com)".

I don't know which table has problems.

I just need to know the default collation for each of the tables.

Darren VanBuren
onekopaka at gmail.com

Administrator of Onekopakaspace (http://oks.verymad.net/).