sys.fulltext_languages (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

ColumnData typeDescription
lcidintMicrosoft Windows locale identifier (LCID) for the language.
namesysnameIs 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.

LanguageLCID
Arabic1025
Bengali (India)1093
British English2057
Bulgarian1026
Catalan1027
Chinese (Hong Kong SAR, PRC)3076
Chinese (Macao SAR)5124
Chinese (Singapore)4100
Croatian1050
Czech1029
Danish1030
Dutch1043
English1033
French1036
German1031
Applies to: SQL Server 2012 through SQL Server 2016.

Greek
1032
Gujarati1095
Hebrew1037
Hindi1081
Icelandic1039
Indonesian1057
Italian1040
Japanese1041
Kannada1099
Korean1042
Latvian1062
Lithuanian1063
Malay - Malaysia1086
Malayalam1100
Marathi1102
Neutral0
Norwegian (Bokmål)1044
Applies to: SQL Server 2012 through SQL Server 2016.

Polish
1045
Portuguese (Brazil)1046
Portuguese (Portugal)2070
Punjabi1094
Romanian1048
Russian1049
Serbian (Cyrillic)3098
Serbian (Latin)2074
Simplified Chinese2052
Slovak1051
Slovenian1060
Spanish3082
Swedish1053
Tamil1097
Telugu1098
Thai1054
Traditional Chinese1028
Applies to: SQL Server 2012 through SQL Server 2016.

Turkish
1055
Ukrainian1058
Urdu1056
Vietnamese1066

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 has been granted some permission.

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

Community Additions

ADD
Show: