Help:Configuration parameter "$smwgFulltextSearchTableOptions"

Jump to: navigation, search
Title $smwgFulltextSearchTableOptions
Description Fulltext search table options
Default setting
'mysql'  => array( 'ENGINE=MyISAM, DEFAULT CHARSET=utf8' ),
'sqlite' => array( 'FTS4' )
Software Semantic MediaWiki
First version supported 2.5.0
Last version supported still available
Configuration Full-text search
Keyword Full-text search

This page is a placeholder for a setting introduced by #1481.1

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' )