title: Sql Server 2008 - Line Break and fulltext queries
body: <p>I have a database and a fulltext indexed table. Lets call this table <code>test</code>. This table has one field called <code>testfield</code>. Now, lets insert only one record as follow:</p>
  
  <pre><code>insert into test values ('word' + Char(13) + 'test')
  </code></pre>
  
  <p>This query inserts a word with a <code>LINE_BREAK</code>. </p>
  
  <p>Now, lets query this table using fulltext:</p>
  
  <pre><code>select * from test where contains(testfield, '"word test"')
  </code></pre>
  
  <p>In that case, this query returns nothing at all. </p>
  
  <p>Also:</p>
  
  <pre><code>select * from test where contains(testfield, '"wordtest"')
  </code></pre>
  
  <p>Returns nothing (that was expected do be this way)</p>
  
  <p>Now, lets query the table again modifying the search word:</p>
  
  <pre><code>select * from test where contains(testfield, '"word' + Char(13) + 'test"')
  </code></pre>
  
  <p>In that case the query returns the correct line. </p>
  
  <p>The question is: Why does this happen? I mean, SQL should ignore line breaks when searching for a word and it does not. I do not believe that this is the default behavior of a fulltext engine. At least it is not acceptable. What happens if my users insert lines with line breaks on my table (and this is usual, since they can write anything they want because the field is an memo field)?</p>
  
  <p>Is there any way of correcting this?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>It only happens when I choose brazilian as the language for FT. If I choose english, none of the problems I mentioned happens.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>On Sql Server Denali CTP3 neither english nor portuguese works. Maybe this is bug in the english steamer. </p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Screenshot for usage of <a href="http://i.stack.imgur.com/xCKRU.png" rel="nofollow">fts_parser</a></p>