title: Sql-server Full Text CONTAINS + COLLATE to ignore accents issues
body: <p>Hi all im struggling a little here with using COLLATE to ignore accents whilst also using Contains full text.</p>
  
  <p>Ive reduced the columns im searching down to just one for the example here, and im hard coding the actual parameter just to simply this until i understand it.</p>
  
  <p>If i have</p>
  
  <pre><code>SELECT 
       Col1,
       Title COLLATE SQL_Latin1_General_Cp850_CI_AI AS Title,
       ColX
  FROM
       Foo
  WHERE 
       CONTAINS((Title),  '"suenos" OR "french"') 
  </code></pre>
  
  <p>This only returns results with french. If i add the wild card after eg:</p>
  
  <pre><code> WHERE 
       CONTAINS((Title),  '"suenos*" OR "french"') 
  </code></pre>
  
  <p>I get results for Sueños and for french. Ive noticed the same behaviour with a LIKE and COLLATE, eg it only words with 'suenous%' as apposed to 'suenos'.</p>
  
  <p>Why is this?</p>
  
  <p>Thanks muchly.</p>