Query Unicode Characters in SQL Server

This N prefix tells SQL Server to treat this string literal as a Unicode string and not convert it to a non-Unicode string (as it will if you omit the N prefix).

select * from [MalayalamNews] where title like N’%ചെന്നിത്തല%’

Add Comment