how to make sql server 2005 search in arabic language?
<p>I have a SQL Server 2005 database in which I have some tables contain Arabic text. The datatype for those fields is NVARCHAR(n).</p>

<p>The Arabic text inside the table is appearing properly, and when selecting using select clause, they appear properly. 
The problem is that searching for Arabic text with where clause results in 0 rows.</p>

<p>select * from table_name
where name=@name  </p>

<p>This retrieves no rows, where there is a name with this value. 
When we use it like:</p>

<p>select * from table_name
where name=N’Arabic_Text’</p>

<p>Then it works, but how we can pass searching text from front end to back end.
Can you please guide me on how to write the query?</p>

<p><strong>PS</strong></p>

<p>In code behind i wrote:</p>

<pre><code>Dim UserName As String = "N'" &amp; txtLogin.Text &amp; "'"
Dim _dtLogin As DataTable = oUser.UserLogin(UserName)
</code></pre>

<p>it returns 0 rows even if that user exist in database.</p>
