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.

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.

Reference

Other Resources

Help and Information