default full-text language Option

Use the default full-text language option to specify a default language value for full-text indexed columns. Linguistic analysis is performed on all data that is full-text indexed and is dependent on the language of the data. The default value of this option is the language of the server.

The value of the default full-text language option is used when no language is specified for a column through the LANGUAGE language_term option in the CREATE FULLTEXT INDEX or ALTER FULLTEXT INDEX statements. If the default full-text language is not supported or the linguistic analysis package is not available, the CREATE or ALTER operation will fail and Microsoft SQL Server will return an error message stating that the language specified is not valid.

For a list of linguistic analysis packages are part of SQL Server 2005 see sys.fulltext_languages (Transact-SQL).

Other languages may also be available from independent software vendors, for example. If no specific language dialect is found, the Microsoft Full-Text Engine for SQL (MSFTESQL) service will automatically switch to the primary language.

The default full-text language option replaces the language neutral full-text option in SQL Server version 7.0. During an upgrade from SQL Server 7.0, the default full-text language value is set based on the values of SQL Server 7.0 configuration options Unicode locale id and language neutral full-text. This behavior maintains compatibility with SQL Server 7.0 applications.

The default full-text language option is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change default full-text language only when show advanced options is set to 1.

See Also


Setting Server Configuration Options

Other Resources

sp_configure (Transact-SQL)
sp_fulltext_column (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance