title: SQL Server - Search for Unicode characters
body: <p>I am using DNN 7 text editor control to pass text to my Stored Procedure:</p>
  
  <p>Cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.NText)).Value = txtMsgTitle.Text;
  Cmd.Parameters.Add(new SqlParameter("@Body", SqlDbType.NText)).Value = teMsgBody.Text;</p>
  
  <p>Before insert/update I have to replace all the html codes like '&amp;aacute ;', '&amp;agrave ;' (please remove spaces) with the equivalent Unicode characters 'á','à' so that when I enter some text to search, it can return correct result for me.</p>
  
  <p>Has anyone got a better solution for this? I have to do the replace many times (say 20 characters) something similar to this link but not that complicated:
  <a href="http://www.stormrage.com/SQLStuff/XML_To_ASCII.txt" rel="nofollow">http://www.stormrage.com/SQLStuff/XML_To_ASCII.txt</a></p>