sql - LIKE not working with NVARCHAR -

i have sql query this:

select *  hr_companies namelang2 '111კომპანია'

but returns no rows. see hr_companies table has column named namelang2 of varchar type. used ltrim rtrim still nothing returned.

please suggest how fix problem facing now.

try this:

declare @tabe table(id int ,data  nvarchar(max))  insert @tabe  values (1,n'नाम'),(2,n'गणेश')  select * @tabe data n'%गणे%'

output:

id    data  2     गणेश

EXIT