Displays Adaptive Server’s default sort order and character set.
sp_helpsort
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 { | } ~
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 ÿ
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.
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
Binary sort order is the default.
Any user can execute sp_helpsort.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|