On Mon, Apr 30, 2018 at 10:57 AM, Jaime Crespo jcrespo@wikimedia.org wrote:
MediaWiki currently doesn't even try to support UTF-8
I thought the installer gave the option to chose between binary and utf8 83-bytes)?
Hmm. Yes, it looks like it does. But if all fields are varbinary, does it matter? Maybe it should be removed from the installer.
There's also a $wgDBmysql5 configuration setting, which controls whether MediaWiki does "SET NAMES 'utf8'" or "SET NAMES 'binary'". I don't know what difference this makes, maybe none since all the columns are varbinary.
innodb_large_preffix cannot be enabled anymore because it is enabled (hardcoded) automatically on MySQL 8.0.
That's good, once we raise the supported version that far. Currently it looks like we still support 5.5.8, which at least has the setting to enable.