O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required