Chinese collation for MS SQL

Question

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'                

            

标签： sql-server tsql localization chinese-locale

举报

Answer 1

After some investigation I found standard GB 18030 which defines the required language and character support necessary for software in China. And I found that Microsoft's System Center Configuration Manager is compatible with this standard only in case that db collation is set to one of following:

• Chinese_Simplified_Pinyin_100_CI_AI
• Chinese_Simplified_Stroke_Order_100_CI_AI

Our customer prefer stroke order so I tried Chinese_Simplified_Stroke_Order_100_CI_AI and it works fine.

Even if it is not answer why Chinese_PRC_CI_AS does not work or more details about Chinese_PRC_BIN sort it's applicable solution.