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

No matter which value is selected here, MediaWiki internally always produces data in UTF-8 encoding to be saved in the database. Thus a conversion is never needed. Since binary charsets prevent MySQL from doing charset conversions, which otherwise unnecessarily might take place the recommended setting is the default setting.

The following setting is no longer available in current versions due to dropped MySQL 4 support:
 * MySQL 4.0 backwards-compatible UTF-8: TYPE=InnoDB