Managing Full-Text Search
SQL Server supports all languages that are supported by Microsoft Windows operating systems. To help the Database Engine perform searches efficiently, you should set the default language for full-text searches, manage stopwords and stoplists, and configure the thesaurus file.
Setting the Default Full-Text Language
When you select a default full-text language, the Database Engine uses that language to index data stored in char, nchar, varchar, nvarchar, text, and ntext columns. This language is also the default language used at query time if the language_term clause is not specified as part of a full-text search. If you don’t set a default full-text language, this option is set the same as the default language for the SQL ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant 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.
