Discussion Locked

ASCII sort

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

What is the sequence on an ASCII sort?
what is first letters, numbers, simbols or spaces

9 replies

by syscokid

Well, when I create a table in Access and do a sort ascending, I get spaces, symbols, numbers, letters.

by larry h.

The list below uses the US English character set:

! " # $ % & ' ( ) * + , - . / 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 { | } ~  ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ' ' " " o - - ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?

by larry h.

I forgot to mention, the space comes first. These numbers can be viewed by using Excel's CHAR( ) function on numbers 32-255.

by aringland

I found a really nice table at pcguide.com that includes the entire character set with dec, bin and hex conversions. And yes, after the control characters (NUL, SOH, etc..) the space if first.

This discussion is closed to new replies.