sys.fulltext_languages (Transact-SQL)
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—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 Transact-SQL statements.
Column |
Data type |
Description |
|---|---|---|
lcid |
int |
Microsoft 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 |
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 |
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 |
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 |
Vietnamese |
1066 |
Remarks
To update the list of languages registered with full-text search, use sp_fulltext_service 'update_languages'.
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.
See Also
Reference
sp_fulltext_load_thesaurus_file (Transact-SQL)
sp_fulltext_service (Transact-SQL)
Concepts
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