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. |
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 |
To update the list of languages registered with full-text search, use sp_fulltext_service 'update_languages'.
