Chinese collation for MS SQL

问题:

I found in our production DB for Asia market weird behavior. Where condition is not working as one would expect in case of Chinese letters.

create table #Temp  (TextContent nvarchar(20), ChineseType varchar(10))

insert #Temp values (N'㱔', '??')  --odd
insert #Temp values (N'