default full-text language

Type: Advanced

Default value: 1033

The default full-text language option is used 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 strictly 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 option in the CREATE FULLTEXT INDEX or ALTER FULLTEXT INDEX statements. If the default full-text language option is not supported or the linguistic analysis package is not available, the CREATE or ALTER operation doesn’t work, and SQL Server returns an invalid language ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.