Thread:Project:Support desk/MySQL 1267: Illegal mix of collations when wgUseTeX=true (math on)/reply

Okay, digging into this more, the wikidb math table create syntax is

mysql> show create table math; CREATE TABLE `math` ( `math_inputhash` varchar(16) NOT NULL DEFAULT ,  `math_outputhash` varchar(16) NOT NULL DEFAULT ,  `math_html_conservativeness` tinyint(1) NOT NULL DEFAULT '0',  `math_html` text,  `math_mathml` text,  UNIQUE KEY `math_inputhash` (`math_inputhash`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | -

and the offending query appears to be

SELECT math_outputhash,math_html_conservativeness,math_html,math_mathml  FROM `math`  WHERE math_inputhash = '�j��-�4m!����9R�'  LIMIT 1;

I'm guessing the math_inputhash is not encoded the way mysql/wikimedia wants it.

Do others math table have charset=latin1? Is there a column charset I can check? Any ideas? 129.2.141.139 17:49, 30 September 2010 (UTC)