title: SQL Server search in nvarchar & ntext
body: <p>I'm using SQL Server 2008 as my database engine in a VS2010, C# ASP.NET web app. My project is Farsi (Persian) so I've used <code>nvarchar</code> and <code>ntext</code> as my data types. </p>
  
  <p>I use following query to find rows from my database but nothing is returned, while I have a row with the specified keyword. Of course my keyword is in Persian (unicode). </p>
  
  <p>What is going wrong here? Is it because of using Farsi language? How can I search in <code>nvarchar</code> and <code>ntext</code> columns containing unicode characters?</p>
  
  <pre><code>myCommand = new SqlCommand("select * from tblArticle where name LIKE '%" + txtSearch.Text + "%'", SQLConnection);
  </code></pre>