title: Using LIKE with domestic language in SQL
body: <p>I am using a SQL Server database, and I am storing <code>Malayalam</code> names in my tables. I just want to write a query for filtering names using some Malayalam words.</p>
  
  <pre><code>SELECT * FROM table WHERE mal_Name LIKE '@word%'
  </code></pre>
  
  <p><code>@word</code> contain <code>Malayalam words</code>.</p>
  
  <p>How can I achieve this? Please share any ideas.</p>
  
  <p>EDIT</p>
  
  <p><img src="https://i.stack.imgur.com/LGB3A.png" alt="This is my table, rm_Malayalam_name contains Malayalam name"></p>
  
  <p>This is my table, rm_Malayalam_name contains Malayalam name. And my Query is </p>
  
  <pre><code>SELECT * 
  FROM Purchase.tblRawMaterials 
  WHERE rm_malayalam_name LIKE '%കദളിപഴം%'
  </code></pre>
  
  <p>It doesn't work. The entry is there but while executing this query nothing is shown</p>