Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
This catalog view contains one row per language whose word breakers are registered with SQL Server. Each row displays the LCID and name of the language.
When word breakers are registered for a language, its other linguistic resources (such as stemmers, noise words or 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 Transact-SQL statements.
| Column | Data type | Description |
|---|---|---|
lcid |
int | 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. |
Values returned for default languages
The following table shows values for the languages whose word breakers are registered by default.
| Language | LCID |
|---|---|
| Arabic | 1025 |
| Bangla 1 | 2117 |
| Bengali (India) | 1093 |
| Bokmål | 1044 |
| Brazilian 1 | 1046 |
| 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 |
| Estonian 1 | 1061 |
| Finnish 1 | 1035 |
| French | 1036 |
| German | 1031 |
| Greek 1 | 1032 |
| Gujarati | 1095 |
| Hebrew | 1037 |
| Hindi | 1081 |
| Hungarian 1 | 1038 |
| 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 1 | 2068 |
| Polish 1 | 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 1 | 1055 |
| Ukrainian | 1058 |
| Urdu | 1056 |
| Vietnamese | 1066 |
1 Applies to: SQL Server 2025 (17.x) and later versions.
Remarks
To update the list of languages registered with full-text search, use sp_fulltext_service with the update_languages option.
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission.
Related content
- sp_fulltext_load_thesaurus_file (Transact-SQL)
- sp_fulltext_service (Transact-SQL)
- Configure and manage word breakers and stemmers for search (SQL Server)
- Configure and Manage Thesaurus Files for Full-Text Search
- Configure and Manage Stopwords and Stoplists for Full-Text Search
- Upgrade Full-Text Search