Archive for the 'MediaWiki' Category

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 with it is binary tables created by very old (~ the year 2007) version of MediaWiki, text columns are latin1 encoding and latin1_bin collation. If you try to run them with the current version of MediaWiki, you get following error:
Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' ()