Column-Level Linguistic Analysis
Linguistic analysis is performed on all full-text indexed data. Linguistic analysis involves finding word boundaries (word-breaking) and conjugating verbs (stemming). The rules for this analysis differ for different languages, and you can specify a different language for each full-text indexed column. Microsoft® SQL Server™ 2000 includes linguistic analysis packages for these locales.
Use neutral when a column contains data in multiple languages or in an unsupported language.
The linguistic analysis performed on arguments to the full-text query functions, CONTAINS, FREETEXT, CONTAINSTABLE, and FREETEXTTABLE, is determined by the language of the full-text indexed column being queried. If no language is specified for a column, the default is the value of the configuration option, 'default full-text language'.
For a localized version of SQL Server, SQL Server Setup sets the default full-text language option to the language of the server if an appropriate match exists. For a nonlocalized version of SQL Server, the default full-text language option defaults to neutral.
Note All columns listed in a single full-text query function clause must use the same language.
The default full-text language configuration option replaces the language neutral full-text option in SQL Server version 7.0. During an upgrade from SQL Server 7.0 to SQL Server 2000, the default full-text language value is set, based on the values of the Unicode locale id and language neutral full-text options.