补充说明:
在SQL7的查询分析器中运行SP_HELPSORT,结果如下:
Unicode data sorting
----------------------
Locale ID = 2052 case insensitive, kana type insensitive, width insensitive
Sort Order Description
------------------------------------------------------------------------------------------------------------------------------------
Character Set = 14, cp936
Code page 936
Sort Order = 199, nls_cp936
NLS Case-Insensitive Sort Order for the Code Page 936 Character Set
在SQL2000中结果为
Chinese-PRC, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive
在SQL7的查询分析器中运行SP_HELPSORT,结果如下:
Unicode data sorting
----------------------
Locale ID = 2052 case insensitive, kana type insensitive, width insensitive
Sort Order Description
------------------------------------------------------------------------------------------------------------------------------------
Character Set = 14, cp936
Code page 936
Sort Order = 199, nls_cp936
NLS Case-Insensitive Sort Order for the Code Page 936 Character Set
在SQL2000中结果为
Chinese-PRC, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货