title: "sys.fulltext_languages (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "06/10/2016" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "sys.fulltext_languages"
- "sys.fulltext_languages_TSQL"
- "fulltext_languages"
- "fulltext_languages_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "languages [full-text search]"
- "sys.fulltext_languages catalog view" ms.assetid: 2ed6b53d-1cf2-4763-9d58-36ea24a610ef caps.latest.revision: 54 author: "douglaslMS" ms.author: "douglasl" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]
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] through [!INCLUDEssCurrent]. 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] through [!INCLUDEssCurrent]. 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] through [!INCLUDEssCurrent]. 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