SQL Query and Unicode Issue

Question

I have a really weird issue with Sql queries on unicode data. Here's what I've got:

• Sql Server Express 2008 R2 AS
• Table containing chinese characters/words/phrases (100,000 rows)

When I run the following, I get the correct row + 36 other rows returned... when it should only be the one row:

SELECT TOP 1000 [ID]
      ,[MyChineseColumn]
      ,UNICODE([MyChineseColumn])
  FROM [dbo].[MyTableName]
  WHERE [MyChineseColumn]= N'㐅'

As you'd expect, the row with 㐅 is returned, but also the following: 〇, 宁, 㮸 and a bunch of others...

Anyone have any ideas what is going on here? This has really got me confused and I am not sure how to solve this one (tried "Googling" already)...

Thanks

Answer 1

Please check the column is using an appropriate Chinese collation as that will determine the semantics used in this type of comparison.