sp_helpsort

语法


sp_helpsort

示例

示例 1

对于 1 类（单字节）字符集，sp_helpsort 显示服务器缺省排序顺序的名称、其字符集以及其主排序值表。在 7 位终端上，显示内容如下：


sp_helpsort


<h2>Sort Order Description </h2>
 Character Set = 1, iso_1
     ISO 8859-1 (Latin-1) - Western European 8-bit character set.
 Sort Order = 50, bin_iso_1
     Binary sort order for the ISO 8859/1 character set (iso_1).
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 [ \ ] ^ _
   <code> 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 { | } ~
   ! “ # $ % & ‘ ( ) * + , - . / 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 { | } ~

示例 2

在 8 位终端上，显示内容如下：


<h2>Sort Order Description </h2>
 Character Set = 1, iso_1
     ISO 8859-1 (Latin-1) - Western European 8-bit character set.
 Sort Order = 50, bin_iso_1
     Binary sort order for the ISO 8859/1 character set (iso_1).
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 { | } ~
  ¡ ¢ £ ¤ ¥ | § ¨ © ª  ¬ – ® ¯ ˚  2 3 ´ µ ¶ · ¸ 1 º  1/4 1/2 3/4 ¿ À
  Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï D Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Y P ß à
  á â ã ä å æ ç è é ê ë ì í î ï  ñ ò ó ô õ ö ÷ ø ù ú û ü y p ÿ

示例 3

对于类 2（多字节）字符集，将不列出字符，但包括该字符集的说明。例如：


<h2>Sort Order Description </h2>
Character Set = 140, euc_jis
    Japanese. Extended Unix Code mapping for JIS-X0201
    (hankaku katakana) and JIS-X0208 (double byte) roman,
     kana, and kanji.
    Class 2 character set
Sort Order = 50, bin_eucjis
    Binary sort order for Japanese using the EUC JIS
      character set as a basis.

示例 4

对于不区分大小写的字符集，将列出不区分大小写的可用排序顺序的名称和 ID：


<h2>Name                   ID</h2>
nocase_eucgb           52
nocase_cp936           52
nocase_gb18030         52
nocase_eucjis          52
nocase_sjis            52
nocase_deckanji        52

用法

二进制排序顺序是缺省设置。