Archive for September, 2014

How to convert old binary MediaWiki tables to UTF-8

Wednesday, September 3rd, 2014

I’ve been using Mediawiki for a long time now. One problem about it is binary tables created by very old (~year 2007) version of MediaWiki, text columns are latin1 encoding and latin1_bin collation. If you try to run them with current version of MediaWiki, you get following error:
Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' ()