sp_helpsort

Syntax

sp_helpsort

Parameters

• None. –

Examples

• Example 1 – For Class 1 (single-byte) character sets, sp_helpsort displays the name of the server’s default sort order, its character set, and a table of its primary sort values. On a 7-bit terminal, it appears as follows:

  sp_helpsort

  Sort Order Description 
  -----------------------------------------------------------------
   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 { | } ~
     ! “ # $ % & ‘ ( ) * + , - . / 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 { | } ~

• Example 2 – On an 8-bit terminal, it appears as follows:

  Sort Order Description 
  -----------------------------------------------------------------
   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 ÿ

• Example 3 – For a Class 2 (multibyte) character set, the characters are not listed, but a description of the character set is included. For example:

  Sort Order Description 
  -----------------------------------------------------------------
  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.

• Example 4 – For case-insensitive character sets, the name and sort order ID of available case-insensitive sort orders is listed:

  Name                   ID
  -------------------------
  nocase_eucgb           52
  nocase_cp936           52
  nocase_gb18030         52
  nocase_eucjis          52
  nocase_sjis            52
  nocase_deckanji        52

Usage

Binary sort order is the default.

Permissions

Any user can execute sp_helpsort. Permission checks do not differ based on the granular permissions settings.

Auditing

Values in event and extrainfo columns from the sysaudits table are: