|MySQL specific: $wgDBTableOptions|
|MySQL table options to use during installation or update.
|Introduced in version:||1.10.0 (r21466)|
|Removed in version:||still in use|
|Default value:||'ENGINE=InnoDB, DEFAULT CHARSET=binary'|
|Other settings: Alphabetical | By function|
MySQL table options to use during installation or update. $wgDBTableOptions will be set in the LocalSettings.php file generated by the installer. You can choose one of the following options resulting in the according values:
- MySQL binary
- ENGINE=InnoDB, DEFAULT CHARSET=binary
- MySQL UTF-8
- ENGINE=InnoDB, DEFAULT CHARSET=utf8
Note: 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.
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".
|MediaWiki version:||≤ 1.18|
The following setting is no longer available in current versions due to dropped MySQL 4 support:
- MySQL 4.0 backwards-compatible UTF-8