Q:

SQL Query and Unicode Issue

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

A:

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

