SQL LIKE statement using using unicode characters does not show correct result

Question

I'm using SQL Server 2008 R2. I'm just wondering why this statement doesn't work correctly.

For example: The statement

WHERE CONTRACTORNAME LIKE '%á%' 

would gives me the correct result for every records containing "á". But the statement

WHERE CONTRACTORNAME LIKE '%ạ%' 

would not gives any records even though in CONTRACTORNAME column have a tons of records containing this character. Any help?

Answer 1

Try using a Unicode search string:

WHERE CONTRACTORNAME LIKE N'%ạ%'