How Can I Select Gujarati Data In Sql Server

See more:

C#

ASP.NET

SQL-Server

Hello,

I have table named

Tbl_Employee

No    Name (nvarchar(max))
1     મારશલ
2     કેમરુન
3     બ્રાઉન

now i want to search like

select * from Tbl_Employee where Name = 'કેમરુન'

or

select * from Tbl_Employee where Name like '%' + 'કેમરુન' + '%'

but doesn't return any record.
how can i accomplish it.

If any other idea to manage gujarati please help

Thanks in Advance. Thanks a lot