sys.fulltext_languages (Transact-SQL)

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-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
Applies to: SQL Server 2012 (11.x) and later.

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: SQL Server 2012 (11.x) and later.

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: SQL Server 2012 (11.x) and later.

Ukrainian 1058
Urdu 1056
Vietnamese 1066


To update the list of languages registered with full-text search, use sp_fulltext_service'update_languages'.


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.

See Also

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