| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.fulltext_languages (Transact-SQL) |
sys.fulltext_languages (Transact-SQL) |
rwestMSFT |
randolphwest |
mikeray |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
This catalog view contains one row per language whose word breakers are registered with [!INCLUDEssNoVersion]. Each row displays the LCID and name of the language. When word breakers are registered for a language, its other linguistic resources-stemmers, noise words (stopwords), and thesaurus files-become available to full-text indexing/querying operations. The value of name or lcid can be specified in the full-text queries and full-text index [!INCLUDEtsql] statements.
| Column | Data type | Description |
|---|---|---|
| lcid | int | [!INCLUDEmsCoName] Windows locale identifier (LCID) for the language. |
| name | sysname | Is either the value of the alias in sys.syslanguages corresponding to the value of lcid or the string representation of the numeric LCID. |
The following table shows values for the languages whose word breakers are registered by default.
| Language | LCID |
|---|---|
| Arabic | 1025 |
| Bengali (India) | 1093 |
| British English | 2057 |
| Bulgarian | 1026 |
| Catalan | 1027 |
| Chinese (Hong Kong SAR, PRC) | 3076 |
| Chinese (Macao SAR) | 5124 |
| Chinese (Singapore) | 4100 |
| Croatian | 1050 |
| Czech | 1029 |
| Danish | 1030 |
| Dutch | 1043 |
| English | 1033 |
| French | 1036 |
| German | 1031 |
| Applies to: [!INCLUDEssSQL11] and later. Greek |
1032 |
| Gujarati | 1095 |
| Hebrew | 1037 |
| Hindi | 1081 |
| Icelandic | 1039 |
| Indonesian | 1057 |
| Italian | 1040 |
| Japanese | 1041 |
| Kannada | 1099 |
| Korean | 1042 |
| Latvian | 1062 |
| Lithuanian | 1063 |
| Malay - Malaysia | 1086 |
| Malayalam | 1100 |
| Marathi | 1102 |
| Neutral | 0 |
| Norwegian (Bokmål) | 1044 |
| Applies to: [!INCLUDEssSQL11] and later. 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 |
| Applies to: [!INCLUDEssSQL11] and later. Turkish |
1055 |
| Ukrainian | 1058 |
| Urdu | 1056 |
| Vietnamese | 1066 |
To update the list of languages registered with full-text search, use sp_fulltext_service'update_languages'.
[!INCLUDEssCatViewPerm]
sp_fulltext_load_thesaurus_file (Transact-SQL)
sp_fulltext_service (Transact-SQL)
Configure and Manage Word Breakers and Stemmers for Search
Configure and Manage Thesaurus Files for Full-Text Search
Configure and Manage Stopwords and Stoplists for Full-Text Search
Upgrade Full-Text Search