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.
The word breakers for most languages are registered by default. However, a number of licensed third-party word breakers are disabled by default. For information about these languages and how to register these word breakers, see How to: Load Licensed Third-Party Word Breakers.
Microsoft Windows locale identifier (LCID) for the language.
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 only the languages whose word breakers are registered by default. For a list of the names and LCIDs for languages whose word breakers that are disabled by default, see "Values for Languages of Third-Party Word Breakers," later in this topic.
Chinese (Hong Kong SAR, PRC)
Chinese (Macau SAR)
Malay - Malaysia1
1 Support for this language was added in SQL Server 2008.
The following table lists the values that are returned for third-party word breakers, if registered.
To use the word breakers for these languages, you must register them manually. For more information about how to enable these languages, see How to: Load Licensed Third-Party Word Breakers.
SQL Server 2008 includes word breakers for approximately 50 languages, of which 23 also exist in SQL Server 2005. Only the word breakers for English, Korean, Thai, and Chinese (all forms) remain the same. For the other languages, SQL Server 2008 introduces a new generation of word breakers that work substantially better than their SQL Server 2005 equivalents. Potentially, the new word breakers might behave slightly differently from SQL Server 2005 word breakers. For information about updating word breakers after importing a SQL Server 2005 full-text index, see Word Breakers and Stemmers.
To create a noise word (stopword) list for a language, the language be registered with SQL Server.
Thesaurus files are automatically loaded by full-text queries that use the thesaurus. To avoid this first-time performance impact on full-text queries, we recommend that you execute sp_fulltext_load_thesaurus_file.
To update the list of languages registered with full-text search, use sp_fulltext_service 'update_languages'.
In SQL Server 2005 and later versions, 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. For more information, see Metadata Visibility Configuration.