You're looking at an older version of Totara Learn.

Please see Totara 14 help for the latest version.

On this page



Full text search is an optional component of the SQL Server Database Engine. If you didn't select Full text search when you installed SQL Server, run SQL Server setup again to add it.

More information available on the the Microsoft MSQL help documentation. You can also find a step-by-step guide for adding features to an instance of SQL Server on their help documentation.

Full-text search component can be selected from the available features list, when adding new features to the existing MSSQL server edition. Availability of the full text search component depends on the SQL server edition (see the table below).

Features supported by the SQL Server Editions 


MS SQL Server is using 'English' language by default, list of options in the MSSQL full text languages documentation.

$CFG->dboptions['ftslanguage'] = 'English';
$CFG->dboptions['ftslanguage'] = 'German';
$CFG->dboptions['ftslanguage'] = 'Japanese';
$CFG->dboptions['ftslanguage'] = 1028; // Traditional Chinese
$CFG->dboptions['ftslanguage'] = 2052; // Simplified Chinese

Minimum search term length

MS SQL Server don't have specific default length and may find the words as long as it's a dictionary word.

Stop words 

Stop words is a dictionary of words that will be excluded from index and search query. They depend on language being used during indexing and search as well as dictionary presence for database installation.

eg: if user search for "Hotels in Wellington" then the system excludes "In" words from the search.

More details on MS SQL Server 2017 stop words can be found in Microsoft's SQL documentation

Provide feedback about this page using the link in the bottom right of this page. 

 Still have questions? 

Why not post them in the forums on the Totara Community?

  • No labels