Manual:$wgDBTableOptions/ja

詳細
インストールや更新をする際に使用するMySQLテーブルオプション. $wgDBTableOptions は、インストーラーが生成した LocalSettings.php ファイル内で設定されます. You can choose one of the following options resulting in the according values:


 * MySQL バイナリ: ENGINE=InnoDB, DEFAULT CHARSET=binary
 * MySQL UTF-8: ENGINE=InnoDB, DEFAULT CHARSET=utf8
 * MySQL 4.0 後方互換 UTF-8: TYPE=InnoDB

注:

The keyword "TYPE" was deprecated and is no longer supported by current MySQL versions. If you then use the "TYPE" keyword anyway, you will get an error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "TYPE=InnoDB"". The solution is to use the keyword "ENGINE" instead of "TYPE".

No matter which value is selected here, internally MediaWiki always produces data in UTF-8 encoding to be saved in the database, so that a conversion is never needed. Since binary charsets prevent MySQL from doing charset conversions, which otherwise might take place, but are unnecessary, the advised value is "ENGINE=InnoDB, DEFAULT CHARSET=binary".