title: SQL Server 2008 R2 Full Text Search with FORMSOF and Accent Insensitive
body: <p>I'm using MS SQL Server 2008 R2 with Full Text Search for searching text data stored in different languages.</p>
  
  <p>I'm a bit confused about how <code>CONTAINS</code> predicate works with accents. </p>
  
  <p>When I use the following predicate</p>
  
  <pre><code>CONTAINS([Text], @keywords  , Language @language)
  </code></pre>
  
  <p>on a catalog with <code>ACCENT_SENSITIVITY = OFF</code> the search results are the same for e.g. 'Lächeln' and 'lacheln' when Germany is specified as language. </p>
  
  <p>But if I change the predicate to look like</p>
  
  <pre><code>CONTAINS([Text], FORMSOF(INFLECTIONAL, @keywords)  , Language @language) 
  </code></pre>
  
  <p>then results are different and it seems to me that Accent Insensitivity doesn't work with <code>FORMSOF</code></p>
  
  <p>I've tried to find an answer on MSDN and Google but didn't find anything useful.</p>
  
  <p>Does anybody know why the results are different?</p>
  
  <p>Thanks!</p>