sp_helpsort的值，大家看有问题吗？

ehxz

免费乐捐，感谢支持

WIN平台下，12.50 （EBF10430）用的CP850字符集。
1> sp_helpsort
2> go

 Collation Name                 Collation ID
 ------------------------------ ------------
 defaultml                                 0
 thaidict                                  1
 utf8bin                                   4
 altnoacc                                 39
 altdict                                  45
 altnocsp                                 46
 scandict                                 47
 scannocp                                 48
 binary                                   50
 dict                                     51
 nocase                                   52
 nocasep                                  53
 noaccent                                 54
 espdict                                  55
 espnocs                                  56
 espnoac                                  57
 rusnocs                                  59
 cyrnocs                                  64
 elldict                                  65
 hundict                                  69
 hunnoac                                  70
 hunnocs                                  71
 turknoac                                 73
 turknocs                                 74

 Loadable Sort Table Name
 ------------------------------

Sort Order Description

 ------------------------------------------------------------------
 Character Set = 2, cp850
     Code Page 850 (Multilingual) character set.
 Sort Order = 50, bin_cp850
     Binary ordering, for use with Code Page 850 (cp850).
Characters, in Order

 ------------------------------------------------------------------
     ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
   @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
   ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ 
  

ehxz

最后面为什么出错码？

JohnPhan

for me:

Sort Order Description

Characters, in Order

Collation Name  Collation ID    Loadable Sort Table Name 
--------------   ------------   ------------------------ 

      
     

                                                                  
-                                                                 
Character Set = 1, iso_1                                          
    ISO 8859-1 (Latin-1) - Western European 8-bit character set.  
Sort Order = 52, nocase_iso_1                                     
    Case-insensitive dictionary sort order for use with several We
    stern-European languages including English, French, and German
    .  Uses the ISO 8859-1 character set.                         

                                                                  
-                                                                 
    ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } 
  ~ ???????????????????????????????
  ???0 1 2 3 4 5 6 7 8 9 A=a ??????????????B=b C 
 =c ??D=d E=e ????????F=f G=g H=h I=i ????????J 
 =j K=k L=l M=m N=n ??O=o ????????????P=p Q=q R=r S 
 =s ?T=t U=u ????????V=v W=w X=x Y=y ??

ehxz

测试了一下，cp936好象就没这方面的问题。后面不出类似的东西。