Help:$smwgFulltextSearchTableOptions

is a configuration parameter that sets the full-text search table options to use during installation or update. It is specific to a relational data store and currently supports MySQL/MariaDBCiteRef::gh:smw:1481 and SQLiteCiteRef::gh:smw:1801 while PostgreSQLCiteRef::gh:smw:1956CiteRef::postgres:ft:vector is currently not supported. The configuration parameter was introduced in and is similar to .CiteRef::gh:smw:1481

Default setting
This means that by default either the storage engine "MyISAM" with character encoding "UTF8" for MySQL/MariaDB or "FTS4" for SQLite.

Changing the default setting
To modify the setting to this configuration parameter, add one of the following lines to your "LocalSettings.php" file after the  call:


 * Switching to InnoDB as the default storage engine for MySQL


 * Extending the option description (MySQL 5.7+)


 * Specify extra arguments for the storage engine (SQLite 3.7.4+)

Full-text search support by database management systems
According to sources full-text search support is available by:
 * MySQL version 5.6 or later with only "MyISAM" and "InnoDB" storage engines
 * MariaDB only with "MyISAM" and "Aria" storage engines, from MariaDB 10.0.5 also with the "InnoDB" storage engine and and from MariaDB 10.0.15 with the "Mroonga" storage engine
 * SQLite "FTS3" has been available since version 3.5.0, "FTS4" was added with version 3.7.4, and "FTS5" is available with version 3.9.0