SQL LIKE statement using Unicode characters does not show the correct result

Question

I am using SQL Server 2008 R2. I'm just wondering why this statement is not working correctly.

For example: operator

WHERE CONTRACTORNAME LIKE '%á%' 

will give me the correct result for every entry containing "á". But the statement

 WHERE CONTRACTORNAME LIKE '%ạ%' 

did not return any records, although there are many records in the CONTRACTORNAME column containing this character. Any help?

Answer 1

Try using the Unicode search bar:

 WHERE CONTRACTORNAME LIKE N'%ạ%'