--- # required metadata title: Install SQL Server Full-Text Search on Linux | Microsoft Docs description: This topic describes how to install SQL Server Full-Text Search on Linux. author: rothja ms.author: jroth manager: jhubbard ms.date: 2/17/2017 ms.topic: article ms.prod: sql-linux ms.technology: database-engine ms.assetid: bb42076f-e823-4cee-9281-cd3f83ae42f5 # optional metadata # keywords: "" # ROBOTS: "" # audience: "" # ms.devlang: "" # ms.reviewer: "" # ms.suite: "" # ms.tgt_pltfrm: "" # ms.custom: "" --- # Install SQL Server Full-Text Search on Linux The following steps install SQL Server Full-Text Search (**mssql-server-fts**) on Linux. [SQL Server Full-Text Search](https://msdn.microsoft.com/library/ms142571.aspx) enables you to run full-text queries against character-based data in SQL Server tables. For information about Full-Text Search known issues for this release, see the [Release Notes](sql-server-linux-release-notes.md). > [!NOTE] > Before installing SQL Server Full-Text Search, first [install SQL Server](sql-server-linux-setup.md#platforms). This configures the keys and repositories that you use when installing the **mssql-server-fts** package. Install SQL Server Full-Text Search for your platform: - [Red Hat Enterprise Linux](#RHEL) - [Ubuntu](#ubuntu) - [SUSE Linux Enterprise Server](#SLES) ## Install on RHEL Use the following commands to install the **mssql-server-fts** on Red Hat Enterprise Linux. ```bash sudo yum update sudo yum install mssql-server-fts ``` If you already have **mssql-server-fts** installed, you can update to the latest version with the following commands: ```bash sudo yum check-update sudo yum update mssql-server-fts ``` ## Install on Ubuntu Use the following commands to install the **mssql-server-fts** on Ubuntu. ```bash sudo apt-get update sudo apt-get install mssql-server-fts ``` If you already have **mssql-server-fts** installed, you can update to the latest version with the following commands: ```bash sudo apt-get update sudo apt-get install mssql-server-fts ``` ## Install on SLES Use the following commands to install the **mssql-server-fts** on SUSE Linux Enterprise Server. ```bash sudo zypper install mssql-server-fts ``` If you already have **mssql-server-fts** installed, you can update to the latest version with the following commands: ```bash sudo zypper refresh sudo zypper update mssql-server-fts ``` ## Supported languages Full-Text Search uses [word breakers](https://msdn.microsoft.com/library/ms142509.aspx) that determine how to identify individual words based on language. You can get a list of registered word breakers by querying the **sys.fulltext_languages** catalog view. Word breakers for the following languages are installed with SQL Server vNext CTP 1.3: | Language | Language ID | |---|---| | Arabic | 1025 | | Bengali (India) | 1093 | | British English | 2057 | | Bulgarian | 1026 | | Catalan | 1027 | | Croatian | 1050 | | Danish | 1030 | | Dutch | 1043 | | English | 1033 | | French | 1036 | | German | 1031 | | Gujarati | 1095 | | Hebrew | 1037 | | Hindi | 1081 | | Icelandic | 1039 | | Indonesian | 1057 | | Italian | 1040 | | Japanese | 1041 | | Kannada | 1099 | | Latvian | 1062 | | Lithuanian | 1063 | | Malay - Malaysia | 1086 | | Malayalam | 1100 | | Marathi | 1102 | | Neutral | 0 | | Norwegian (Bokmål) | 1044 | | Polish | 1045 | | Portuguese (Brazil) | 1046 | | Portuguese (Portugal) | 2070 | | Punjabi | 1094 | | Romanian | 1048 | | Russian | 1049 | | Serbian (Cyrillic) | 3098 | | Serbian (Latin) | 2074 | | Simplified Chinese | 2052 | | Slovak | 1051 | | Slovenian | 1060 | | Spanish | 3082 | | Swedish | 1053 | | Tamil | 1097 | | Telugu | 1098 | | Thai | 1054 | | Traditional Chinese | 1028 | | Turkish | 1055 | | Ukrainian | 1058 | | Urdu | 1056 | ## Filters Full-Text Search also works with text stored in binary files. But in this case, an installed filter is required to process the file. For more information about filters, see [Configure and Manage Filters for Search](https://msdn.microsoft.com/library/ms142499.aspx). You can see a list of installed filters by calling **sp_help_fulltext_system_components 'filter'**. For SQL Server vNext CTP 1.3, the following filters are installed: | Component Name | Class ID | Version | |---|---|---| |.a C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.ans | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.asc | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.ascx | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.asm | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.asp | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.aspx | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.asx | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.bas | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.bat | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.bcp | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.c | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.cc | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.cls | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.cmd | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.cpp | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.cs | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.csa | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.css | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.csv | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.cxx | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.dbs | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.def | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.dic | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.dos | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.dsp | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.dsw | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.ext | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.faq | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.fky | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.h | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.hhc | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.hpp | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.hta | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.htm | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.html | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.htt | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.htw | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.htx | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.hxx | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.i | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.ibq | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.ics | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.idl | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.idq | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.inc | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.inf | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.ini | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.inl | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.inx | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.jav | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.java | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.js | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.kci | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.lgn | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.log | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.lst | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.m3u | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.mak | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.mk | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.odc | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.odh | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.odl | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.pkgdef | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.pkgundef | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.pl | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.prc | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.rc | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.rc2 | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.rct | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.reg | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.rgs | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.rtf | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.rul | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.s | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.scc | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.shtm | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.shtml | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.snippet | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.sol | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.sor | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.srf | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.stm | E0CA5340-4534-11CF-B952-00AA0051FE20 | 12.0.6828.0 |.tab | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.tdl | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.tlh | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.tli | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.trg | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.txt | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.udf | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.udt | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.url | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.usr | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.vbs | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.viw | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.vsct | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.vsixlangpack | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.vsixmanifest | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.vspscc | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.vsscc | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.vssscc | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.wri | C1243CA0-BF96-11CD-B579-08002B30BFEB | 12.0.6828.0 |.wtx | C7310720-AC80-11D1-8DF3-00C04FB6EF4F | 12.0.6828.0 |.xml | 41B9BE05-B3AF-460C-BF0B-2CDD44A093B1 | 12.0.9735.0 ## Next steps For more information on how to use SQL Server Agent to create, schedule, and run jobs, see [Run a SQL Server Agent job on Linux](sql-server-linux-run-sql-server-agent-job.md).