Part2 – SQL Full text Search and International Characters: Interesting Scenarios, solutions and deep-dive using DMV’s

Continuing on my last post which dealt with Chinese characters, I will cover some user scenarios on Germanic characters like German/Swedish/Norwegian with SQL FTS. Read on… Scenario1 – German language  Mr Customer: Hey, we have some full text search catalogs for German words, and we noticed that FREETEXTTABLE fails to find text clearly defined in…


Part1 – SQL Full text Search and International Characters: Interesting Scenarios, solutions and deep-dive using DMV’s

As part of my work I come across varied scenarios that customers encounter with SQL Server. I recently had the opportunity to work on some interesting scenarios using SQL Full-text search and international characters (non-English). To most people, the concept of word-breaking especially with non-English characters is still a mystery. In this blog series, I will…