title: What is good variable type for full text search in SQL Server
body: <p>I am declaring a new stored procedure in MS SQL Server for implementing Full Text Search and my query is some thing like this:</p>
  
  <pre><code>Select * from table WHERE FREETEXT((col1, col2), @Search_Statement)
  </code></pre>
  
  <p>The question has exactly written bellow:</p>
  
  <p>What is the proper data type for @Search_Statement variable to support most of searches and also have the best performance?</p>
  
  <p>(I know that if I make @Search_Statement variable long it supports more search queries but executing queries with longer @Search_Statement may affect performance and google limit search queries to 32 words: <a href="https://www.linkedin.com/grp/post/1176637-216124982" rel="nofollow">https://www.linkedin.com/grp/post/1176637-216124982</a>)</p>
  
  <p>I don't know which of these datatypes to use for @Search_Statement in my stored procedure: Nvarchar(100), Nvarchar(500) or Nvarchar(MAX)
  Which would be the best choice? (Performance, and all other aspects)</p>
  
  <p><strong>Update</strong>: I know I should use nvarchar but what is proper size of nvarchar? nvarchar(100),(200),(500),... or even nvarchar(MAX)?</p>