sys.fulltext_languages (Transact-SQL)
This catalog view contains one row per language available for full-text indexing/querying operations. Each row provides an unambiguous representation of the available full-text linguistic resources that are registered with Microsoft SQL Server. The name or lcid can be specified in the full-text queries and full-text index DDL
| Column Name | Data Type | Description |
|---|---|---|
lcid |
int |
Microsoft Windows local ID for the language. |
name |
sysname |
Is either the value of the alias in syslanguages corresponding to the value of lcid, or is the string representation of the numeric lcid. |
Table returned
| LCID | Name |
|---|---|
2052 |
Simplified Chinese |
1028 |
Traditional Chinese |
1030 |
Danish |
1031 |
German |
2057 |
British English |
1033 |
English |
3082 |
Spanish |
1036 |
French |
1040 |
Italian |
1041 |
Japanese |
1042 |
Korean |
0 |
Neutral |
1043 |
Dutch |
1045 |
Polish |
1046 |
Brazilian |
2070 |
Portuguese |
1049 |
Russian |
1053 |
Swedish |
1054 |
Thai |
1055 |
Turkish |
3076 |
Chinese (Hong Kong SAR, PRC) |
5124 |
Chinese (Macau SAR) |
4100 |
Chinese (Singapore) |
Note
The following languages must be manually enabled for full-text indexing: Danish, Polish, Portuguese-Brazil, Portuguese-Portugal, Russian, and Turkish. For more information about how to enable these languages, see Knowledge Base article 908441 at Microsoft Help and Support.
See Also
Reference
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
14 April 2006 |
|