https://bugzilla.wikimedia.org/show_bug.cgi?id=21964
Summary: math markup results in MySQL error "1267: Illegal mix of
collations"
Product: MediaWiki
Version: 1.15.1
Platform: PC
OS/Version: Linux
Status: NEW
Severity: normal
Priority: Normal
Component: Page rendering
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: r...@mokeys.org
If I try to preview/save a page containing math markup such as
"<math>\alpha^2+\beta^2=1</math>", then I get the following error:
A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was:
SELECT math_outputhash,math_html_conservativeness,math_html,math_mathml FROM
`math` WHERE math_inputhash = '�s ...@��uo�&Z�f�' LIMIT 1
from within function "MathRenderer::_recall". MySQL returned error "1267:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_unicode_ci,COERCIBLE) for operation '=' (sql)".
Some people suggested setting $wgDBmysql5 to false which did not work. MySQL
lists the math table as having a latin1_swedish_ci collation; all text/varchar
columns on that table also have a latin1_swedish_ci collation.
FYI, my MySQL version is 5.0.26
Any help would be appreciated.
Thanks,
Ross
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
