Help:Configuration parameter $smwgFulltextSearchTableOptions
|Description||Fulltext search table options|
'mysql' => array( 'ENGINE=MyISAM, DEFAULT CHARSET=utf8' ),
'sqlite' => array( 'FTS4' )
|Introduced with version||2.5|
|Removed with version||still available|
|Configuration||Configuration is missing|
Fulltext search table options
This setting directly influences how a ft table is created therefore please change the content with caution.
- MySQL version 5.6 or later with only MyISAM and InnoDB storage engines to support full-text search (according to sources)
- MariaDB full-text indexes can be used only with MyISAM and Aria tables, from MariaDB 10.0.5 with InnoDB tables and from MariaDB 10.0.15 with Mroonga tables (according to sources)
- SQLite FTS3 has been available since version 3.5, FTS4 were added with version 3.7.4, and FTS5 is available with version 3.9.0 (according to sources); The setting allows to specify extra arguments after the module engine such as array( 'FTS4', 'tokenize=porter' ).
It is possible to extend the option decription (MySQL 5.7+) with 'mysql' => array( 'ENGINE=MyISAM, DEFAULT CHARSET=utf8', 'WITH PARSER ngram' )