I get the following error (when recreating table data on the Cargo extension, but I'm sure it's not that extension's fault) for pages with some non-English characters (e.g. in the name Šikuta):
Function: Wikimedia\Rdbms\Database::select
Error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Looking at my MediaWiki database, it seems to be a mixture of utf_general_ci and latin1_swedish_ci. The Cargo database is all latin1_swedish_ci. The default collation for both is latin1_swedish_ci.
I think I need to alter each latin1_swedish_ci table so that it is utf_general_ci and change the default for future tables being created.
Is this the solution? Would there be any unintended consequences of doing this? Is there an easy way you could recommend (e.g. a maintenance script which already exists)? Thanks. ~~~~