Column-Level Linguistic Analysis

Creating and Maintaining Databases

Creating and Maintaining Databases

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.

Neutral German
Chinese_Simplified Italian
Chinese_Traditional Japanese
Dutch Korean
English_UK Spanish_Modern
English_US Swedish_Default
French  

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.

See Also

sp_fulltext_column