title: CONTAINSTABLE with wildcard works different in SQL Server 2005 and SQL Server 2008?
body: <p>I have two same databases one on SQL Server 2005 and one on SQL Server 2008, it have same SQL_Latin1_General_CP1_CI_AS Collation, and full text search catalogs have the same settings.</p>
  
  <p>These two databases contains table with same data, NTEXT string: 
  "...kræve en forklaring fra miljøminister Connie Hedegaard.."</p>
  
  <p><strong>My problem is:</strong></p>
  
  <p>CONTAINSTABLE on SQL Server 2008 finds nothing if query is: </p>
  
  <pre><code>select * from ContainsTable(SearchIndex_7, Content, N'"miljø*"') ct
  </code></pre>
  
  <p>but SQL Server 2005 works perfectly and finds necessary record.</p>
  
  <p>SQL Server 2008 finds necessary record if query is:</p>
  
  <pre><code>select * from ContainsTable(SearchIndex_7, Content, N'"milj*"') ct
  </code></pre>
  
  <p>or  </p>
  
  <pre><code>select * from ContainsTable(SearchIndex_7, Content, N'"miljøminister"')
  </code></pre>
  
  <p>What can be reason for so strange behavior? </p>