I have a RadGrid in asp.net application which is bound to a ObjectDataSource. Everything works great except filtering.
I traced the query on SQL Server Profiler and found out ...where columnName like '%arabic text%' which is not returning any row.
if you change this to...where columnName like N'%arabic text%' it gives you the correct result.
Is there any solution or work around?.
Thanks
Kesava.
I traced the query on SQL Server Profiler and found out ...where columnName like '%arabic text%' which is not returning any row.
if you change this to...where columnName like N'%arabic text%' it gives you the correct result.
Is there any solution or work around?.
Thanks
Kesava.