Using sql server management studio, I want to create a full text index where a certain field is treated as html, tags should be ignored and umlaut-codes should be taken into account. How can I do that?

1 Answer 1


From at least SQL Server 2008 R2 SQL Server comes with an understanding of HTML.

http://msdn.microsoft.com/en-us/library/ms142499.aspx says: " SQL Server installs its own XML and HTML filters. In addition, any filters for Microsoft proprietary formats (.doc, .xdoc, .ppt and so on) that are already installed on the operating system are also loaded by SQL Server."

You mention umlauts, but not what you want to do with them. Umlauts and other characters that may seem unusual to English readers, can be managed by choosing the proper collation for the Index. Also the chosen Word Breaker (Neutral, English, French, etc) will affect your results.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.