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?

Possible duplicate of http://stackoverflow.com/questions/4251765/how-to-use-like-statement-with-unicode-strings — lukiffer, Jul 06 '12 at 15:37

score 17 · Answer 1 · answered Jul 06 '12 at 15:40

17

Try using a Unicode search string:

WHERE CONTRACTORNAME LIKE N'%ạ%'

answered Jul 06 '12 at 15:40

Kevin Aenmey

1 Answers1