set names ascii;
select 'e'='`';
'e'='`'
0
select 'y'='~';
'y'='~'
0
create table t1 (a char(1) character set ascii);
insert into t1 (a) values (' '), ('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'), ('!'), ('@'), ('#'), ('$'), ('%'), ('^'), ('&'), ('*'), ('('), (')'), ('_'), ('+'), ('`'), ('~'), ('1'), ('2'), ('3'), ('4'), ('5'), ('6'), ('7'), ('8'), ('9'), ('0'), ('['), (']'), ('\\'), ('|'), ('}'), ('{'), ('"'), (':'), (''''), (';'), ('/'), ('.'), (','), ('?'), ('>'), ('<'), ('\n'), ('\t'), ('\a'), ('\f'), ('\v');
select t1a.a, t1b.a from t1 as t1a, t1 as t1b where t1a.a=t1b.a order by binary t1a.a, binary t1b.a;
a	a
	
			

	

!	!
"	"
#	#
$	$
%	%
&	&
'	'
(	(
)	)
*	*
+	+
,	,
.	.
/	/
0	0
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
:	:
;	;
<	<
>	>
?	?
@	@
A	A
A	a
A	a
B	B
B	b
C	C
C	c
D	D
D	d
E	E
E	e
F	F
F	f
F	f
G	G
G	g
H	H
H	h
I	I
I	i
J	J
J	j
K	K
K	k
L	L
L	l
M	M
M	m
N	N
N	n
O	O
O	o
P	P
P	p
Q	Q
Q	q
R	R
R	r
S	S
S	s
T	T
T	t
U	U
U	u
V	V
V	v
V	v
W	W
W	w
X	X
X	x
Y	Y
Y	y
Z	Z
Z	z
[	[
\	\
]	]
^	^
_	_
`	`
a	A
a	A
a	a
a	a
a	a
a	a
b	B
b	b
c	C
c	c
d	D
d	d
e	E
e	e
f	F
f	F
f	f
f	f
f	f
f	f
g	G
g	g
h	H
h	h
i	I
i	i
j	J
j	j
k	K
k	k
l	L
l	l
m	M
m	m
n	N
n	n
o	O
o	o
p	P
p	p
q	Q
q	q
r	R
r	r
s	S
s	s
t	T
t	t
u	U
u	u
v	V
v	V
v	v
v	v
v	v
v	v
w	W
w	w
x	X
x	x
y	Y
y	y
z	Z
z	z
{	{
|	|
}	}
~	~
drop table t1;
End of 5.0 tests.