1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
|
DROP TABLE IF EXISTS `ascii`;
CREATE TABLE `ascii` (
`i` int(11) NOT NULL AUTO_INCREMENT,
`c` char(64) NOT NULL,
PRIMARY KEY (`i`),
UNIQUE KEY `c` (`c`)
) ENGINE=MyISAM AUTO_INCREMENT=143 DEFAULT CHARSET=latin1;
INSERT INTO `ascii` VALUES (1,''),(2,'M'),(3,'007'),(4,'Penelope'),(5,'Nick'),(6,'Ed'),(7,'Jennifer'),(8,'johnny'),(9,'Bette'),(10,'Grace'),(11,'matthew'),(12,'joe'),(13,'christian'),(14,'zero'),(15,'karl'),(16,'uma'),(17,'vivien'),(18,'Cuba'),(19,'Fred'),(20,'Helen'),(21,'Dan'),(22,'Bob'),(23,'<[MEGATRON]>'),(24,'Lucille'),(25,'Kirsten'),(26,'Elvis'),(27,'Sandra'),(28,'Cameron'),(29,'Kevin'),(30,'Rip'),(31,'Julia'),(32,'Jean-Luc'),(33,'Woody'),(34,'Alec'),(35,'Sissy'),(36,'tim'),(37,'milla'),(38,'audrey'),(39,'judy'),(40,'burt'),(41,'val'),(42,'tom'),(43,'goldie'),(44,'jodie'),(45,'kirk'),(46,'reese'),(47,'parker'),(48,'Frances'),(49,'Anne'),(50,'Natalie'),(51,'Gary'),(52,'Carmen'),(53,'@the ball park'),(54,'Mena'),(55,'Fay'),(56,'Jude'),(57,'Dustin'),(58,'Henry'),(59,'jayne'),(60,'Ray'),(61,'Angela'),(62,'Mary'),(63,'Jessica'),(64,'kenneth'),(65,'Michelle'),(66,'adam'),(67,'Sean'),(68,'Angelina'),(69,'Cary'),(70,'Groucho'),(71,'Mae'),(72,'Ralph'),(73,'Scarlett'),(74,'Ben'),(75,'bling$$$'),(76,'James'),(77,'Minnie'),(78,'Greg'),(79,'spencer'),(80,'charlize'),(81,'christopher'),(82,'Ellen'),(83,'Daryl'),(84,'Gene'),(85,'Meg'),(86,'Chris'),(87,'jim'),(88,'susan'),(89,'walter'),(90,'sidney'),(91,'gina'),(92,'warren'),(93,'Sylvester'),(94,'Russell'),(95,'Morgan'),(96,'Harrison'),(97,'Renee'),(98,'Liza'),(99,'Salma'),(100,'Julianne'),(101,'Albert'),(102,'Cate'),(103,'Greta'),(104,'jane'),(105,'richard'),(106,'rita'),(107,'ewan'),(108,'whoopi'),(109,'jada'),(110,'River'),(111,'Kim'),(112,'Emily'),(113,'Geoffrey'),(114,'meryl'),(115,'Ian'),(116,'Laura'),(117,'Harvey'),(118,'Oprah'),(119,'Humphrey'),(120,'Al'),(121,'laurence'),(122,'will'),(123,'olympia'),(124,'alan'),(125,'michael'),(126,'william'),(127,'jon'),(128,'Mr. Peanut'),(129,'Mr. Rogers'),(130,'lisa'),(131,'Jeff'),(132,'Debbie'),(133,'Rock'),(134,'Gregory'),(135,'John'),(136,'Bela'),(137,'Thora'),(138,'Zesus'),(139,'Zesus!'),(140,'Zesus!!'),(141,'ZESUS!!!'),(142,'001');
--
-- Here's how MySQL sorts these values on my machine:
--
-- | 1 | |
-- | 2 | 001 |
-- | 3 | 007 |
-- | 4 | <[MEGATRON]> |
-- | 5 | @the ball park |
-- | 6 | adam |
-- | 7 | Al |
-- | 8 | alan |
-- | 9 | Albert |
-- | 10 | Alec |
-- | 11 | Angela |
-- | 12 | Angelina |
-- | 13 | Anne |
-- | 14 | audrey |
-- | 15 | Bela |
-- | 16 | Ben |
-- | 17 | Bette |
-- | 18 | bling$$$ |
-- | 19 | Bob |
-- | 20 | burt |
-- | 21 | Cameron |
-- | 22 | Carmen |
-- | 23 | Cary |
-- | 24 | Cate |
-- | 25 | charlize |
-- | 26 | Chris |
-- | 27 | christian |
-- | 28 | christopher |
-- | 29 | Cuba |
-- | 30 | Dan |
-- | 31 | Daryl |
-- | 32 | Debbie |
-- | 33 | Dustin |
-- | 34 | Ed |
-- | 35 | Ellen |
-- | 36 | Elvis |
-- | 37 | Emily |
-- | 38 | ewan |
-- | 39 | Fay |
-- | 40 | Frances |
-- | 41 | Fred |
-- | 42 | Gary |
-- | 43 | Gene |
-- | 44 | Geoffrey |
-- | 45 | gina |
-- | 46 | goldie |
-- | 47 | Grace |
-- | 48 | Greg |
-- | 49 | Gregory |
-- | 50 | Greta |
-- | 51 | Groucho |
-- | 52 | Harrison |
-- | 53 | Harvey |
-- | 54 | Helen |
-- | 55 | Henry |
-- | 56 | Humphrey |
-- | 57 | Ian |
-- | 58 | jada |
-- | 59 | James |
-- | 60 | jane |
-- | 61 | jayne |
-- | 62 | Jean-Luc |
-- | 63 | Jeff |
-- | 64 | Jennifer |
-- | 65 | Jessica |
-- | 66 | jim |
-- | 67 | jodie |
-- | 68 | joe |
-- | 69 | John |
-- | 70 | johnny |
-- | 71 | jon |
-- | 72 | Jude |
-- | 73 | judy |
-- | 74 | Julia |
-- | 75 | Julianne |
-- | 76 | karl |
-- | 77 | kenneth |
-- | 78 | Kevin |
-- | 79 | Kim |
-- | 80 | kirk |
-- | 81 | Kirsten |
-- | 82 | Laura |
-- | 83 | laurence |
-- | 84 | lisa |
-- | 85 | Liza |
-- | 86 | Lucille |
-- | 87 | M |
-- | 88 | Mae |
-- | 89 | Mary |
-- | 90 | matthew |
-- | 91 | Meg |
-- | 92 | Mena |
-- | 93 | meryl |
-- | 94 | michael |
-- | 95 | Michelle |
-- | 96 | milla |
-- | 97 | Minnie |
-- | 98 | Morgan |
-- | 99 | Mr. Peanut |
-- | 100 | Mr. Rogers |
-- | 101 | Natalie |
-- | 102 | Nick |
-- | 103 | olympia |
-- | 104 | Oprah |
-- | 105 | parker |
-- | 106 | Penelope |
-- | 107 | Ralph |
-- | 108 | Ray |
-- | 109 | reese |
-- | 110 | Renee |
-- | 111 | richard |
-- | 112 | Rip |
-- | 113 | rita |
-- | 114 | River |
-- | 115 | Rock |
-- | 116 | Russell |
-- | 117 | Salma |
-- | 118 | Sandra |
-- | 119 | Scarlett |
-- | 120 | Sean |
-- | 121 | sidney |
-- | 122 | Sissy |
-- | 123 | spencer |
-- | 124 | susan |
-- | 125 | Sylvester |
-- | 126 | Thora |
-- | 127 | tim |
-- | 128 | tom |
-- | 129 | uma |
-- | 130 | val |
-- | 131 | vivien |
-- | 132 | walter |
-- | 133 | warren |
-- | 134 | whoopi |
-- | 135 | will |
-- | 136 | william |
-- | 137 | Woody |
-- | 138 | zero |
-- | 139 | Zesus |
-- | 140 | Zesus! |
-- | 141 | Zesus!! |
-- | 142 | ZESUS!!! |
|
