DROP TABLE IF EXISTS t1;
SET CHARACTER SET latin1;
CREATE TABLE t1 (
comment CHAR(32) ASCII NOT NULL,
koi8_ru_f CHAR(32) CHARACTER SET koi8r NOT NULL default ''
) CHARSET=latin5;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `comment` char(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `koi8_ru_f` char(32) CHARACTER SET koi8r COLLATE koi8r_general_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin5 COLLATE=latin5_turkish_ci
ALTER TABLE t1 CHANGE comment comment CHAR(32) CHARACTER SET latin2 NOT NULL;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `comment` char(32) CHARACTER SET latin2 COLLATE latin2_general_ci NOT NULL,
  `koi8_ru_f` char(32) CHARACTER SET koi8r COLLATE koi8r_general_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin5 COLLATE=latin5_turkish_ci
ALTER TABLE t1 ADD latin5_f CHAR(32) NOT NULL;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `comment` char(32) CHARACTER SET latin2 COLLATE latin2_general_ci NOT NULL,
  `koi8_ru_f` char(32) CHARACTER SET koi8r COLLATE koi8r_general_ci NOT NULL DEFAULT '',
  `latin5_f` char(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin5 COLLATE=latin5_turkish_ci
ALTER TABLE t1 DEFAULT CHARSET=latin2;
ALTER TABLE t1 ADD latin2_f CHAR(32) NOT NULL;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `comment` char(32) NOT NULL,
  `koi8_ru_f` char(32) CHARACTER SET koi8r COLLATE koi8r_general_ci NOT NULL DEFAULT '',
  `latin5_f` char(32) CHARACTER SET latin5 COLLATE latin5_turkish_ci NOT NULL,
  `latin2_f` char(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_general_ci
ALTER TABLE t1 DROP latin2_f, DROP latin5_f;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `comment` char(32) NOT NULL,
  `koi8_ru_f` char(32) CHARACTER SET koi8r COLLATE koi8r_general_ci NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_general_ci
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('a','LAT SMALL A');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('b','LAT SMALL B');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('c','LAT SMALL C');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('d','LAT SMALL D');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('e','LAT SMALL E');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('f','LAT SMALL F');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('g','LAT SMALL G');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('h','LAT SMALL H');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('i','LAT SMALL I');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('j','LAT SMALL J');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('k','LAT SMALL K');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('l','LAT SMALL L');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('m','LAT SMALL M');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('n','LAT SMALL N');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('o','LAT SMALL O');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('p','LAT SMALL P');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('q','LAT SMALL Q');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('r','LAT SMALL R');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('s','LAT SMALL S');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('t','LAT SMALL T');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('u','LAT SMALL U');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('v','LAT SMALL V');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('w','LAT SMALL W');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('x','LAT SMALL X');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('y','LAT SMALL Y');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('z','LAT SMALL Z');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('A','LAT CAPIT A');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('B','LAT CAPIT B');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('C','LAT CAPIT C');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('D','LAT CAPIT D');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('E','LAT CAPIT E');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('F','LAT CAPIT F');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('G','LAT CAPIT G');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('H','LAT CAPIT H');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('I','LAT CAPIT I');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('J','LAT CAPIT J');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('K','LAT CAPIT K');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('L','LAT CAPIT L');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('M','LAT CAPIT M');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('N','LAT CAPIT N');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('O','LAT CAPIT O');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('P','LAT CAPIT P');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('Q','LAT CAPIT Q');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('R','LAT CAPIT R');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('S','LAT CAPIT S');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('T','LAT CAPIT T');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('U','LAT CAPIT U');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('V','LAT CAPIT V');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('W','LAT CAPIT W');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('X','LAT CAPIT X');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('Y','LAT CAPIT Y');
INSERT INTO t1 (koi8_ru_f,comment) VALUES ('Z','LAT CAPIT Z');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL A');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL BE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL VE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL GE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL DE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL IE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL IO');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL ZHE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL ZE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL I');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL KA');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL EL');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL EM');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL EN');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL O');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL PE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL ER');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL ES');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL TE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL U');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL EF');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL HA');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL TSE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL CHE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL SHA');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL SCHA');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL HARD SIGN');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL YERU');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL SOFT SIGN');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL E');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL YU');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR SMALL YA');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT A');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT BE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT VE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT GE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT DE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT IE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT IO');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT ZHE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT ZE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT I');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT KA');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT EL');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT EM');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT EN');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT O');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT PE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT ER');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT ES');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT TE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT U');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT EF');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT HA');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT TSE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT CHE');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT SHA');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT SCHA');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT HARD SIGN');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT YERU');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT SOFT SIGN');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT E');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT YU');
INSERT INTO t1 (koi8_ru_f,comment) VALUES (_koi8r'�','CYR CAPIT YA');
SET CHARACTER SET utf8;
SELECT koi8_ru_f,MIN(comment),COUNT(*) FROM t1 GROUP BY 1;
koi8_ru_f	MIN(comment)	COUNT(*)
a	LAT CAPIT A	2
b	LAT CAPIT B	2
c	LAT CAPIT C	2
d	LAT CAPIT D	2
e	LAT CAPIT E	2
f	LAT CAPIT F	2
g	LAT CAPIT G	2
h	LAT CAPIT H	2
i	LAT CAPIT I	2
j	LAT CAPIT J	2
k	LAT CAPIT K	2
l	LAT CAPIT L	2
m	LAT CAPIT M	2
n	LAT CAPIT N	2
o	LAT CAPIT O	2
p	LAT CAPIT P	2
q	LAT CAPIT Q	2
r	LAT CAPIT R	2
s	LAT CAPIT S	2
t	LAT CAPIT T	2
u	LAT CAPIT U	2
v	LAT CAPIT V	2
w	LAT CAPIT W	2
x	LAT CAPIT X	2
y	LAT CAPIT Y	2
z	LAT CAPIT Z	2
а	CYR CAPIT A	2
б	CYR CAPIT BE	2
в	CYR CAPIT VE	2
г	CYR CAPIT GE	2
д	CYR CAPIT DE	2
е	CYR CAPIT IE	2
ё	CYR CAPIT IO	2
ж	CYR CAPIT ZHE	2
з	CYR CAPIT ZE	2
и	CYR CAPIT I	2
к	CYR CAPIT KA	2
л	CYR CAPIT EL	2
м	CYR CAPIT EM	2
н	CYR CAPIT EN	2
о	CYR CAPIT O	2
п	CYR CAPIT PE	2
р	CYR CAPIT ER	2
с	CYR CAPIT ES	2
т	CYR CAPIT TE	2
у	CYR CAPIT U	2
ф	CYR CAPIT EF	2
х	CYR CAPIT HA	2
ц	CYR CAPIT TSE	2
ч	CYR CAPIT CHE	2
ш	CYR CAPIT SHA	2
щ	CYR CAPIT SCHA	2
ъ	CYR CAPIT HARD SIGN	2
ы	CYR CAPIT YERU	2
ь	CYR CAPIT SOFT SIGN	2
э	CYR CAPIT E	2
ю	CYR CAPIT YU	2
я	CYR CAPIT YA	2
ALTER TABLE t1 ADD utf8_f CHAR(32) CHARACTER SET utf8 NOT NULL default '';
UPDATE t1 SET utf8_f=CONVERT(koi8_ru_f USING utf8);
SET CHARACTER SET koi8r;
SELECT * FROM t1;
comment	koi8_ru_f	utf8_f
LAT SMALL A	a	a
LAT SMALL B	b	b
LAT SMALL C	c	c
LAT SMALL D	d	d
LAT SMALL E	e	e
LAT SMALL F	f	f
LAT SMALL G	g	g
LAT SMALL H	h	h
LAT SMALL I	i	i
LAT SMALL J	j	j
LAT SMALL K	k	k
LAT SMALL L	l	l
LAT SMALL M	m	m
LAT SMALL N	n	n
LAT SMALL O	o	o
LAT SMALL P	p	p
LAT SMALL Q	q	q
LAT SMALL R	r	r
LAT SMALL S	s	s
LAT SMALL T	t	t
LAT SMALL U	u	u
LAT SMALL V	v	v
LAT SMALL W	w	w
LAT SMALL X	x	x
LAT SMALL Y	y	y
LAT SMALL Z	z	z
LAT CAPIT A	A	A
LAT CAPIT B	B	B
LAT CAPIT C	C	C
LAT CAPIT D	D	D
LAT CAPIT E	E	E
LAT CAPIT F	F	F
LAT CAPIT G	G	G
LAT CAPIT H	H	H
LAT CAPIT I	I	I
LAT CAPIT J	J	J
LAT CAPIT K	K	K
LAT CAPIT L	L	L
LAT CAPIT M	M	M
LAT CAPIT N	N	N
LAT CAPIT O	O	O
LAT CAPIT P	P	P
LAT CAPIT Q	Q	Q
LAT CAPIT R	R	R
LAT CAPIT S	S	S
LAT CAPIT T	T	T
LAT CAPIT U	U	U
LAT CAPIT V	V	V
LAT CAPIT W	W	W
LAT CAPIT X	X	X
LAT CAPIT Y	Y	Y
LAT CAPIT Z	Z	Z
CYR SMALL A	�	�
CYR SMALL BE	�	�
CYR SMALL VE	�	�
CYR SMALL GE	�	�
CYR SMALL DE	�	�
CYR SMALL IE	�	�
CYR SMALL IO	�	�
CYR SMALL ZHE	�	�
CYR SMALL ZE	�	�
CYR SMALL I	�	�
CYR SMALL KA	�	�
CYR SMALL EL	�	�
CYR SMALL EM	�	�
CYR SMALL EN	�	�
CYR SMALL O	�	�
CYR SMALL PE	�	�
CYR SMALL ER	�	�
CYR SMALL ES	�	�
CYR SMALL TE	�	�
CYR SMALL U	�	�
CYR SMALL EF	�	�
CYR SMALL HA	�	�
CYR SMALL TSE	�	�
CYR SMALL CHE	�	�
CYR SMALL SHA	�	�
CYR SMALL SCHA	�	�
CYR SMALL HARD SIGN	�	�
CYR SMALL YERU	�	�
CYR SMALL SOFT SIGN	�	�
CYR SMALL E	�	�
CYR SMALL YU	�	�
CYR SMALL YA	�	�
CYR CAPIT A	�	�
CYR CAPIT BE	�	�
CYR CAPIT VE	�	�
CYR CAPIT GE	�	�
CYR CAPIT DE	�	�
CYR CAPIT IE	�	�
CYR CAPIT IO	�	�
CYR CAPIT ZHE	�	�
CYR CAPIT ZE	�	�
CYR CAPIT I	�	�
CYR CAPIT KA	�	�
CYR CAPIT EL	�	�
CYR CAPIT EM	�	�
CYR CAPIT EN	�	�
CYR CAPIT O	�	�
CYR CAPIT PE	�	�
CYR CAPIT ER	�	�
CYR CAPIT ES	�	�
CYR CAPIT TE	�	�
CYR CAPIT U	�	�
CYR CAPIT EF	�	�
CYR CAPIT HA	�	�
CYR CAPIT TSE	�	�
CYR CAPIT CHE	�	�
CYR CAPIT SHA	�	�
CYR CAPIT SCHA	�	�
CYR CAPIT HARD SIGN	�	�
CYR CAPIT YERU	�	�
CYR CAPIT SOFT SIGN	�	�
CYR CAPIT E	�	�
CYR CAPIT YU	�	�
CYR CAPIT YA	�	�
ALTER TABLE t1 ADD bin_f CHAR(1) BYTE NOT NULL default '';
UPDATE t1 SET bin_f=koi8_ru_f;
SELECT COUNT(DISTINCT bin_f),COUNT(DISTINCT koi8_ru_f),COUNT(DISTINCT utf8_f) FROM t1;
COUNT(DISTINCT bin_f)	COUNT(DISTINCT koi8_ru_f)	COUNT(DISTINCT utf8_f)
116	58	57
SELECT koi8_ru_f,MIN(comment) FROM t1 GROUP BY 1;
koi8_ru_f	MIN(comment)
a	LAT CAPIT A
b	LAT CAPIT B
c	LAT CAPIT C
d	LAT CAPIT D
e	LAT CAPIT E
f	LAT CAPIT F
g	LAT CAPIT G
h	LAT CAPIT H
i	LAT CAPIT I
j	LAT CAPIT J
k	LAT CAPIT K
l	LAT CAPIT L
m	LAT CAPIT M
n	LAT CAPIT N
o	LAT CAPIT O
p	LAT CAPIT P
q	LAT CAPIT Q
r	LAT CAPIT R
s	LAT CAPIT S
t	LAT CAPIT T
u	LAT CAPIT U
v	LAT CAPIT V
w	LAT CAPIT W
x	LAT CAPIT X
y	LAT CAPIT Y
z	LAT CAPIT Z
�	CYR CAPIT A
�	CYR CAPIT BE
�	CYR CAPIT VE
�	CYR CAPIT GE
�	CYR CAPIT DE
�	CYR CAPIT IE
�	CYR CAPIT IO
�	CYR CAPIT ZHE
�	CYR CAPIT ZE
�	CYR CAPIT I
�	CYR CAPIT KA
�	CYR CAPIT EL
�	CYR CAPIT EM
�	CYR CAPIT EN
�	CYR CAPIT O
�	CYR CAPIT PE
�	CYR CAPIT ER
�	CYR CAPIT ES
�	CYR CAPIT TE
�	CYR CAPIT U
�	CYR CAPIT EF
�	CYR CAPIT HA
�	CYR CAPIT TSE
�	CYR CAPIT CHE
�	CYR CAPIT SHA
�	CYR CAPIT SCHA
�	CYR CAPIT HARD SIGN
�	CYR CAPIT YERU
�	CYR CAPIT SOFT SIGN
�	CYR CAPIT E
�	CYR CAPIT YU
�	CYR CAPIT YA
SELECT utf8_f,MIN(comment) FROM t1 GROUP BY 1;
utf8_f	MIN(comment)
a	LAT CAPIT A
b	LAT CAPIT B
c	LAT CAPIT C
d	LAT CAPIT D
e	LAT CAPIT E
f	LAT CAPIT F
g	LAT CAPIT G
h	LAT CAPIT H
i	LAT CAPIT I
j	LAT CAPIT J
k	LAT CAPIT K
l	LAT CAPIT L
m	LAT CAPIT M
n	LAT CAPIT N
o	LAT CAPIT O
p	LAT CAPIT P
q	LAT CAPIT Q
r	LAT CAPIT R
s	LAT CAPIT S
t	LAT CAPIT T
u	LAT CAPIT U
v	LAT CAPIT V
w	LAT CAPIT W
x	LAT CAPIT X
y	LAT CAPIT Y
z	LAT CAPIT Z
�	CYR CAPIT A
�	CYR CAPIT BE
�	CYR CAPIT VE
�	CYR CAPIT GE
�	CYR CAPIT DE
�	CYR CAPIT IE
�	CYR CAPIT ZHE
�	CYR CAPIT ZE
�	CYR CAPIT I
�	CYR CAPIT KA
�	CYR CAPIT EL
�	CYR CAPIT EM
�	CYR CAPIT EN
�	CYR CAPIT O
�	CYR CAPIT PE
�	CYR CAPIT ER
�	CYR CAPIT ES
�	CYR CAPIT TE
�	CYR CAPIT U
�	CYR CAPIT EF
�	CYR CAPIT HA
�	CYR CAPIT TSE
�	CYR CAPIT CHE
�	CYR CAPIT SHA
�	CYR CAPIT SCHA
�	CYR CAPIT HARD SIGN
�	CYR CAPIT YERU
�	CYR CAPIT SOFT SIGN
�	CYR CAPIT E
�	CYR CAPIT YU
�	CYR CAPIT YA
SELECT DISTINCT koi8_ru_f FROM t1;
koi8_ru_f
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
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
SELECT DISTINCT utf8_f FROM t1;
utf8_f
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
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
SELECT lower(koi8_ru_f) FROM t1 ORDER BY 1 DESC;
lower(koi8_ru_f)
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
z
z
y
y
x
x
w
w
v
v
u
u
t
t
s
s
r
r
q
q
p
p
o
o
n
n
m
m
l
l
k
k
j
j
i
i
h
h
g
g
f
f
e
e
d
d
c
c
b
b
a
a
SELECT lower(utf8_f) FROM t1 ORDER BY 1 DESC;
lower(utf8_f)
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
z
z
y
y
x
x
w
w
v
v
u
u
t
t
s
s
r
r
q
q
p
p
o
o
n
n
m
m
l
l
k
k
j
j
i
i
h
h
g
g
f
f
e
e
d
d
c
c
b
b
a
a
SELECT t11.comment,t12.comment 
FROM t1 t11,t1 t12 WHERE CONVERT(t11.koi8_ru_f USING utf8)=t12.utf8_f
ORDER BY t11.koi8_ru_f,t11.comment,t12.comment;
comment	comment
LAT CAPIT A	LAT CAPIT A
LAT CAPIT A	LAT SMALL A
LAT SMALL A	LAT CAPIT A
LAT SMALL A	LAT SMALL A
LAT CAPIT B	LAT CAPIT B
LAT CAPIT B	LAT SMALL B
LAT SMALL B	LAT CAPIT B
LAT SMALL B	LAT SMALL B
LAT CAPIT C	LAT CAPIT C
LAT CAPIT C	LAT SMALL C
LAT SMALL C	LAT CAPIT C
LAT SMALL C	LAT SMALL C
LAT CAPIT D	LAT CAPIT D
LAT CAPIT D	LAT SMALL D
LAT SMALL D	LAT CAPIT D
LAT SMALL D	LAT SMALL D
LAT CAPIT E	LAT CAPIT E
LAT CAPIT E	LAT SMALL E
LAT SMALL E	LAT CAPIT E
LAT SMALL E	LAT SMALL E
LAT CAPIT F	LAT CAPIT F
LAT CAPIT F	LAT SMALL F
LAT SMALL F	LAT CAPIT F
LAT SMALL F	LAT SMALL F
LAT CAPIT G	LAT CAPIT G
LAT CAPIT G	LAT SMALL G
LAT SMALL G	LAT CAPIT G
LAT SMALL G	LAT SMALL G
LAT CAPIT H	LAT CAPIT H
LAT CAPIT H	LAT SMALL H
LAT SMALL H	LAT CAPIT H
LAT SMALL H	LAT SMALL H
LAT CAPIT I	LAT CAPIT I
LAT CAPIT I	LAT SMALL I
LAT SMALL I	LAT CAPIT I
LAT SMALL I	LAT SMALL I
LAT CAPIT J	LAT CAPIT J
LAT CAPIT J	LAT SMALL J
LAT SMALL J	LAT CAPIT J
LAT SMALL J	LAT SMALL J
LAT CAPIT K	LAT CAPIT K
LAT CAPIT K	LAT SMALL K
LAT SMALL K	LAT CAPIT K
LAT SMALL K	LAT SMALL K
LAT CAPIT L	LAT CAPIT L
LAT CAPIT L	LAT SMALL L
LAT SMALL L	LAT CAPIT L
LAT SMALL L	LAT SMALL L
LAT CAPIT M	LAT CAPIT M
LAT CAPIT M	LAT SMALL M
LAT SMALL M	LAT CAPIT M
LAT SMALL M	LAT SMALL M
LAT CAPIT N	LAT CAPIT N
LAT CAPIT N	LAT SMALL N
LAT SMALL N	LAT CAPIT N
LAT SMALL N	LAT SMALL N
LAT CAPIT O	LAT CAPIT O
LAT CAPIT O	LAT SMALL O
LAT SMALL O	LAT CAPIT O
LAT SMALL O	LAT SMALL O
LAT CAPIT P	LAT CAPIT P
LAT CAPIT P	LAT SMALL P
LAT SMALL P	LAT CAPIT P
LAT SMALL P	LAT SMALL P
LAT CAPIT Q	LAT CAPIT Q
LAT CAPIT Q	LAT SMALL Q
LAT SMALL Q	LAT CAPIT Q
LAT SMALL Q	LAT SMALL Q
LAT CAPIT R	LAT CAPIT R
LAT CAPIT R	LAT SMALL R
LAT SMALL R	LAT CAPIT R
LAT SMALL R	LAT SMALL R
LAT CAPIT S	LAT CAPIT S
LAT CAPIT S	LAT SMALL S
LAT SMALL S	LAT CAPIT S
LAT SMALL S	LAT SMALL S
LAT CAPIT T	LAT CAPIT T
LAT CAPIT T	LAT SMALL T
LAT SMALL T	LAT CAPIT T
LAT SMALL T	LAT SMALL T
LAT CAPIT U	LAT CAPIT U
LAT CAPIT U	LAT SMALL U
LAT SMALL U	LAT CAPIT U
LAT SMALL U	LAT SMALL U
LAT CAPIT V	LAT CAPIT V
LAT CAPIT V	LAT SMALL V
LAT SMALL V	LAT CAPIT V
LAT SMALL V	LAT SMALL V
LAT CAPIT W	LAT CAPIT W
LAT CAPIT W	LAT SMALL W
LAT SMALL W	LAT CAPIT W
LAT SMALL W	LAT SMALL W
LAT CAPIT X	LAT CAPIT X
LAT CAPIT X	LAT SMALL X
LAT SMALL X	LAT CAPIT X
LAT SMALL X	LAT SMALL X
LAT CAPIT Y	LAT CAPIT Y
LAT CAPIT Y	LAT SMALL Y
LAT SMALL Y	LAT CAPIT Y
LAT SMALL Y	LAT SMALL Y
LAT CAPIT Z	LAT CAPIT Z
LAT CAPIT Z	LAT SMALL Z
LAT SMALL Z	LAT CAPIT Z
LAT SMALL Z	LAT SMALL Z
CYR CAPIT A	CYR CAPIT A
CYR CAPIT A	CYR SMALL A
CYR SMALL A	CYR CAPIT A
CYR SMALL A	CYR SMALL A
CYR CAPIT BE	CYR CAPIT BE
CYR CAPIT BE	CYR SMALL BE
CYR SMALL BE	CYR CAPIT BE
CYR SMALL BE	CYR SMALL BE
CYR CAPIT VE	CYR CAPIT VE
CYR CAPIT VE	CYR SMALL VE
CYR SMALL VE	CYR CAPIT VE
CYR SMALL VE	CYR SMALL VE
CYR CAPIT GE	CYR CAPIT GE
CYR CAPIT GE	CYR SMALL GE
CYR SMALL GE	CYR CAPIT GE
CYR SMALL GE	CYR SMALL GE
CYR CAPIT DE	CYR CAPIT DE
CYR CAPIT DE	CYR SMALL DE
CYR SMALL DE	CYR CAPIT DE
CYR SMALL DE	CYR SMALL DE
CYR CAPIT IE	CYR CAPIT IE
CYR CAPIT IE	CYR CAPIT IO
CYR CAPIT IE	CYR SMALL IE
CYR CAPIT IE	CYR SMALL IO
CYR SMALL IE	CYR CAPIT IE
CYR SMALL IE	CYR CAPIT IO
CYR SMALL IE	CYR SMALL IE
CYR SMALL IE	CYR SMALL IO
CYR CAPIT IO	CYR CAPIT IE
CYR CAPIT IO	CYR CAPIT IO
CYR CAPIT IO	CYR SMALL IE
CYR CAPIT IO	CYR SMALL IO
CYR SMALL IO	CYR CAPIT IE
CYR SMALL IO	CYR CAPIT IO
CYR SMALL IO	CYR SMALL IE
CYR SMALL IO	CYR SMALL IO
CYR CAPIT ZHE	CYR CAPIT ZHE
CYR CAPIT ZHE	CYR SMALL ZHE
CYR SMALL ZHE	CYR CAPIT ZHE
CYR SMALL ZHE	CYR SMALL ZHE
CYR CAPIT ZE	CYR CAPIT ZE
CYR CAPIT ZE	CYR SMALL ZE
CYR SMALL ZE	CYR CAPIT ZE
CYR SMALL ZE	CYR SMALL ZE
CYR CAPIT I	CYR CAPIT I
CYR CAPIT I	CYR SMALL I
CYR SMALL I	CYR CAPIT I
CYR SMALL I	CYR SMALL I
CYR CAPIT KA	CYR CAPIT KA
CYR CAPIT KA	CYR SMALL KA
CYR SMALL KA	CYR CAPIT KA
CYR SMALL KA	CYR SMALL KA
CYR CAPIT EL	CYR CAPIT EL
CYR CAPIT EL	CYR SMALL EL
CYR SMALL EL	CYR CAPIT EL
CYR SMALL EL	CYR SMALL EL
CYR CAPIT EM	CYR CAPIT EM
CYR CAPIT EM	CYR SMALL EM
CYR SMALL EM	CYR CAPIT EM
CYR SMALL EM	CYR SMALL EM
CYR CAPIT EN	CYR CAPIT EN
CYR CAPIT EN	CYR SMALL EN
CYR SMALL EN	CYR CAPIT EN
CYR SMALL EN	CYR SMALL EN
CYR CAPIT O	CYR CAPIT O
CYR CAPIT O	CYR SMALL O
CYR SMALL O	CYR CAPIT O
CYR SMALL O	CYR SMALL O
CYR CAPIT PE	CYR CAPIT PE
CYR CAPIT PE	CYR SMALL PE
CYR SMALL PE	CYR CAPIT PE
CYR SMALL PE	CYR SMALL PE
CYR CAPIT ER	CYR CAPIT ER
CYR CAPIT ER	CYR SMALL ER
CYR SMALL ER	CYR CAPIT ER
CYR SMALL ER	CYR SMALL ER
CYR CAPIT ES	CYR CAPIT ES
CYR CAPIT ES	CYR SMALL ES
CYR SMALL ES	CYR CAPIT ES
CYR SMALL ES	CYR SMALL ES
CYR CAPIT TE	CYR CAPIT TE
CYR CAPIT TE	CYR SMALL TE
CYR SMALL TE	CYR CAPIT TE
CYR SMALL TE	CYR SMALL TE
CYR CAPIT U	CYR CAPIT U
CYR CAPIT U	CYR SMALL U
CYR SMALL U	CYR CAPIT U
CYR SMALL U	CYR SMALL U
CYR CAPIT EF	CYR CAPIT EF
CYR CAPIT EF	CYR SMALL EF
CYR SMALL EF	CYR CAPIT EF
CYR SMALL EF	CYR SMALL EF
CYR CAPIT HA	CYR CAPIT HA
CYR CAPIT HA	CYR SMALL HA
CYR SMALL HA	CYR CAPIT HA
CYR SMALL HA	CYR SMALL HA
CYR CAPIT TSE	CYR CAPIT TSE
CYR CAPIT TSE	CYR SMALL TSE
CYR SMALL TSE	CYR CAPIT TSE
CYR SMALL TSE	CYR SMALL TSE
CYR CAPIT CHE	CYR CAPIT CHE
CYR CAPIT CHE	CYR SMALL CHE
CYR SMALL CHE	CYR CAPIT CHE
CYR SMALL CHE	CYR SMALL CHE
CYR CAPIT SHA	CYR CAPIT SHA
CYR CAPIT SHA	CYR SMALL SHA
CYR SMALL SHA	CYR CAPIT SHA
CYR SMALL SHA	CYR SMALL SHA
CYR CAPIT SCHA	CYR CAPIT SCHA
CYR CAPIT SCHA	CYR SMALL SCHA
CYR SMALL SCHA	CYR CAPIT SCHA
CYR SMALL SCHA	CYR SMALL SCHA
CYR CAPIT HARD SIGN	CYR CAPIT HARD SIGN
CYR CAPIT HARD SIGN	CYR SMALL HARD SIGN
CYR SMALL HARD SIGN	CYR CAPIT HARD SIGN
CYR SMALL HARD SIGN	CYR SMALL HARD SIGN
CYR CAPIT YERU	CYR CAPIT YERU
CYR CAPIT YERU	CYR SMALL YERU
CYR SMALL YERU	CYR CAPIT YERU
CYR SMALL YERU	CYR SMALL YERU
CYR CAPIT SOFT SIGN	CYR CAPIT SOFT SIGN
CYR CAPIT SOFT SIGN	CYR SMALL SOFT SIGN
CYR SMALL SOFT SIGN	CYR CAPIT SOFT SIGN
CYR SMALL SOFT SIGN	CYR SMALL SOFT SIGN
CYR CAPIT E	CYR CAPIT E
CYR CAPIT E	CYR SMALL E
CYR SMALL E	CYR CAPIT E
CYR SMALL E	CYR SMALL E
CYR CAPIT YU	CYR CAPIT YU
CYR CAPIT YU	CYR SMALL YU
CYR SMALL YU	CYR CAPIT YU
CYR SMALL YU	CYR SMALL YU
CYR CAPIT YA	CYR CAPIT YA
CYR CAPIT YA	CYR SMALL YA
CYR SMALL YA	CYR CAPIT YA
CYR SMALL YA	CYR SMALL YA
SELECT t11.comment,t12.comment 
FROM t1 t11,t1 t12 
WHERE t11.koi8_ru_f=CONVERT(t12.utf8_f USING koi8r)
ORDER BY t12.utf8_f,t11.comment,t12.comment;
comment	comment
LAT CAPIT A	LAT CAPIT A
LAT CAPIT A	LAT SMALL A
LAT SMALL A	LAT CAPIT A
LAT SMALL A	LAT SMALL A
LAT CAPIT B	LAT CAPIT B
LAT CAPIT B	LAT SMALL B
LAT SMALL B	LAT CAPIT B
LAT SMALL B	LAT SMALL B
LAT CAPIT C	LAT CAPIT C
LAT CAPIT C	LAT SMALL C
LAT SMALL C	LAT CAPIT C
LAT SMALL C	LAT SMALL C
LAT CAPIT D	LAT CAPIT D
LAT CAPIT D	LAT SMALL D
LAT SMALL D	LAT CAPIT D
LAT SMALL D	LAT SMALL D
LAT CAPIT E	LAT CAPIT E
LAT CAPIT E	LAT SMALL E
LAT SMALL E	LAT CAPIT E
LAT SMALL E	LAT SMALL E
LAT CAPIT F	LAT CAPIT F
LAT CAPIT F	LAT SMALL F
LAT SMALL F	LAT CAPIT F
LAT SMALL F	LAT SMALL F
LAT CAPIT G	LAT CAPIT G
LAT CAPIT G	LAT SMALL G
LAT SMALL G	LAT CAPIT G
LAT SMALL G	LAT SMALL G
LAT CAPIT H	LAT CAPIT H
LAT CAPIT H	LAT SMALL H
LAT SMALL H	LAT CAPIT H
LAT SMALL H	LAT SMALL H
LAT CAPIT I	LAT CAPIT I
LAT CAPIT I	LAT SMALL I
LAT SMALL I	LAT CAPIT I
LAT SMALL I	LAT SMALL I
LAT CAPIT J	LAT CAPIT J
LAT CAPIT J	LAT SMALL J
LAT SMALL J	LAT CAPIT J
LAT SMALL J	LAT SMALL J
LAT CAPIT K	LAT CAPIT K
LAT CAPIT K	LAT SMALL K
LAT SMALL K	LAT CAPIT K
LAT SMALL K	LAT SMALL K
LAT CAPIT L	LAT CAPIT L
LAT CAPIT L	LAT SMALL L
LAT SMALL L	LAT CAPIT L
LAT SMALL L	LAT SMALL L
LAT CAPIT M	LAT CAPIT M
LAT CAPIT M	LAT SMALL M
LAT SMALL M	LAT CAPIT M
LAT SMALL M	LAT SMALL M
LAT CAPIT N	LAT CAPIT N
LAT CAPIT N	LAT SMALL N
LAT SMALL N	LAT CAPIT N
LAT SMALL N	LAT SMALL N
LAT CAPIT O	LAT CAPIT O
LAT CAPIT O	LAT SMALL O
LAT SMALL O	LAT CAPIT O
LAT SMALL O	LAT SMALL O
LAT CAPIT P	LAT CAPIT P
LAT CAPIT P	LAT SMALL P
LAT SMALL P	LAT CAPIT P
LAT SMALL P	LAT SMALL P
LAT CAPIT Q	LAT CAPIT Q
LAT CAPIT Q	LAT SMALL Q
LAT SMALL Q	LAT CAPIT Q
LAT SMALL Q	LAT SMALL Q
LAT CAPIT R	LAT CAPIT R
LAT CAPIT R	LAT SMALL R
LAT SMALL R	LAT CAPIT R
LAT SMALL R	LAT SMALL R
LAT CAPIT S	LAT CAPIT S
LAT CAPIT S	LAT SMALL S
LAT SMALL S	LAT CAPIT S
LAT SMALL S	LAT SMALL S
LAT CAPIT T	LAT CAPIT T
LAT CAPIT T	LAT SMALL T
LAT SMALL T	LAT CAPIT T
LAT SMALL T	LAT SMALL T
LAT CAPIT U	LAT CAPIT U
LAT CAPIT U	LAT SMALL U
LAT SMALL U	LAT CAPIT U
LAT SMALL U	LAT SMALL U
LAT CAPIT V	LAT CAPIT V
LAT CAPIT V	LAT SMALL V
LAT SMALL V	LAT CAPIT V
LAT SMALL V	LAT SMALL V
LAT CAPIT W	LAT CAPIT W
LAT CAPIT W	LAT SMALL W
LAT SMALL W	LAT CAPIT W
LAT SMALL W	LAT SMALL W
LAT CAPIT X	LAT CAPIT X
LAT CAPIT X	LAT SMALL X
LAT SMALL X	LAT CAPIT X
LAT SMALL X	LAT SMALL X
LAT CAPIT Y	LAT CAPIT Y
LAT CAPIT Y	LAT SMALL Y
LAT SMALL Y	LAT CAPIT Y
LAT SMALL Y	LAT SMALL Y
LAT CAPIT Z	LAT CAPIT Z
LAT CAPIT Z	LAT SMALL Z
LAT SMALL Z	LAT CAPIT Z
LAT SMALL Z	LAT SMALL Z
CYR CAPIT A	CYR CAPIT A
CYR CAPIT A	CYR SMALL A
CYR SMALL A	CYR CAPIT A
CYR SMALL A	CYR SMALL A
CYR CAPIT BE	CYR CAPIT BE
CYR CAPIT BE	CYR SMALL BE
CYR SMALL BE	CYR CAPIT BE
CYR SMALL BE	CYR SMALL BE
CYR CAPIT VE	CYR CAPIT VE
CYR CAPIT VE	CYR SMALL VE
CYR SMALL VE	CYR CAPIT VE
CYR SMALL VE	CYR SMALL VE
CYR CAPIT GE	CYR CAPIT GE
CYR CAPIT GE	CYR SMALL GE
CYR SMALL GE	CYR CAPIT GE
CYR SMALL GE	CYR SMALL GE
CYR CAPIT DE	CYR CAPIT DE
CYR CAPIT DE	CYR SMALL DE
CYR SMALL DE	CYR CAPIT DE
CYR SMALL DE	CYR SMALL DE
CYR CAPIT IE	CYR CAPIT IE
CYR CAPIT IE	CYR SMALL IE
CYR CAPIT IO	CYR CAPIT IO
CYR CAPIT IO	CYR SMALL IO
CYR SMALL IE	CYR CAPIT IE
CYR SMALL IE	CYR SMALL IE
CYR SMALL IO	CYR CAPIT IO
CYR SMALL IO	CYR SMALL IO
CYR CAPIT ZHE	CYR CAPIT ZHE
CYR CAPIT ZHE	CYR SMALL ZHE
CYR SMALL ZHE	CYR CAPIT ZHE
CYR SMALL ZHE	CYR SMALL ZHE
CYR CAPIT ZE	CYR CAPIT ZE
CYR CAPIT ZE	CYR SMALL ZE
CYR SMALL ZE	CYR CAPIT ZE
CYR SMALL ZE	CYR SMALL ZE
CYR CAPIT I	CYR CAPIT I
CYR CAPIT I	CYR SMALL I
CYR SMALL I	CYR CAPIT I
CYR SMALL I	CYR SMALL I
CYR CAPIT KA	CYR CAPIT KA
CYR CAPIT KA	CYR SMALL KA
CYR SMALL KA	CYR CAPIT KA
CYR SMALL KA	CYR SMALL KA
CYR CAPIT EL	CYR CAPIT EL
CYR CAPIT EL	CYR SMALL EL
CYR SMALL EL	CYR CAPIT EL
CYR SMALL EL	CYR SMALL EL
CYR CAPIT EM	CYR CAPIT EM
CYR CAPIT EM	CYR SMALL EM
CYR SMALL EM	CYR CAPIT EM
CYR SMALL EM	CYR SMALL EM
CYR CAPIT EN	CYR CAPIT EN
CYR CAPIT EN	CYR SMALL EN
CYR SMALL EN	CYR CAPIT EN
CYR SMALL EN	CYR SMALL EN
CYR CAPIT O	CYR CAPIT O
CYR CAPIT O	CYR SMALL O
CYR SMALL O	CYR CAPIT O
CYR SMALL O	CYR SMALL O
CYR CAPIT PE	CYR CAPIT PE
CYR CAPIT PE	CYR SMALL PE
CYR SMALL PE	CYR CAPIT PE
CYR SMALL PE	CYR SMALL PE
CYR CAPIT ER	CYR CAPIT ER
CYR CAPIT ER	CYR SMALL ER
CYR SMALL ER	CYR CAPIT ER
CYR SMALL ER	CYR SMALL ER
CYR CAPIT ES	CYR CAPIT ES
CYR CAPIT ES	CYR SMALL ES
CYR SMALL ES	CYR CAPIT ES
CYR SMALL ES	CYR SMALL ES
CYR CAPIT TE	CYR CAPIT TE
CYR CAPIT TE	CYR SMALL TE
CYR SMALL TE	CYR CAPIT TE
CYR SMALL TE	CYR SMALL TE
CYR CAPIT U	CYR CAPIT U
CYR CAPIT U	CYR SMALL U
CYR SMALL U	CYR CAPIT U
CYR SMALL U	CYR SMALL U
CYR CAPIT EF	CYR CAPIT EF
CYR CAPIT EF	CYR SMALL EF
CYR SMALL EF	CYR CAPIT EF
CYR SMALL EF	CYR SMALL EF
CYR CAPIT HA	CYR CAPIT HA
CYR CAPIT HA	CYR SMALL HA
CYR SMALL HA	CYR CAPIT HA
CYR SMALL HA	CYR SMALL HA
CYR CAPIT TSE	CYR CAPIT TSE
CYR CAPIT TSE	CYR SMALL TSE
CYR SMALL TSE	CYR CAPIT TSE
CYR SMALL TSE	CYR SMALL TSE
CYR CAPIT CHE	CYR CAPIT CHE
CYR CAPIT CHE	CYR SMALL CHE
CYR SMALL CHE	CYR CAPIT CHE
CYR SMALL CHE	CYR SMALL CHE
CYR CAPIT SHA	CYR CAPIT SHA
CYR CAPIT SHA	CYR SMALL SHA
CYR SMALL SHA	CYR CAPIT SHA
CYR SMALL SHA	CYR SMALL SHA
CYR CAPIT SCHA	CYR CAPIT SCHA
CYR CAPIT SCHA	CYR SMALL SCHA
CYR SMALL SCHA	CYR CAPIT SCHA
CYR SMALL SCHA	CYR SMALL SCHA
CYR CAPIT HARD SIGN	CYR CAPIT HARD SIGN
CYR CAPIT HARD SIGN	CYR SMALL HARD SIGN
CYR SMALL HARD SIGN	CYR CAPIT HARD SIGN
CYR SMALL HARD SIGN	CYR SMALL HARD SIGN
CYR CAPIT YERU	CYR CAPIT YERU
CYR CAPIT YERU	CYR SMALL YERU
CYR SMALL YERU	CYR CAPIT YERU
CYR SMALL YERU	CYR SMALL YERU
CYR CAPIT SOFT SIGN	CYR CAPIT SOFT SIGN
CYR CAPIT SOFT SIGN	CYR SMALL SOFT SIGN
CYR SMALL SOFT SIGN	CYR CAPIT SOFT SIGN
CYR SMALL SOFT SIGN	CYR SMALL SOFT SIGN
CYR CAPIT E	CYR CAPIT E
CYR CAPIT E	CYR SMALL E
CYR SMALL E	CYR CAPIT E
CYR SMALL E	CYR SMALL E
CYR CAPIT YU	CYR CAPIT YU
CYR CAPIT YU	CYR SMALL YU
CYR SMALL YU	CYR CAPIT YU
CYR SMALL YU	CYR SMALL YU
CYR CAPIT YA	CYR CAPIT YA
CYR CAPIT YA	CYR SMALL YA
CYR SMALL YA	CYR CAPIT YA
CYR SMALL YA	CYR SMALL YA
SET CHARACTER SET utf8;
ALTER TABLE t1 ADD ucs2_f CHAR(32) CHARACTER SET ucs2;
SET STATEMENT sql_mode = 'NO_ENGINE_SUBSTITUTION' FOR
ALTER TABLE t1 CHANGE ucs2_f ucs2_f CHAR(32) UNICODE NOT NULL;
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0391,'GREEK CAPIT ALPHA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0392,'GREEK CAPIT BETA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0393,'GREEK CAPIT GAMMA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0394,'GREEK CAPIT DELTA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0395,'GREEK CAPIT EPSILON');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x03B1,'GREEK SMALL ALPHA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x03B2,'GREEK SMALL BETA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x03B3,'GREEK SMALL GAMMA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x03B4,'GREEK SMALL DELTA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x03B5,'GREEK SMALL EPSILON');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0531,'ARMENIAN CAPIT AYB');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0532,'ARMENIAN CAPIT BEN');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0533,'ARMENIAN CAPIT GIM');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0534,'ARMENIAN CAPIT DA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0535,'ARMENIAN CAPIT ECH');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0536,'ARMENIAN CAPIT ZA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0561,'ARMENIAN SMALL YAB');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0562,'ARMENIAN SMALL BEN');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0563,'ARMENIAN SMALL GIM');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0564,'ARMENIAN SMALL DA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0565,'ARMENIAN SMALL ECH');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0566,'ARMENIAN SMALL ZA');
ALTER TABLE t1 ADD armscii8_f CHAR(32) CHARACTER SET armscii8 NOT NULL;
ALTER TABLE t1 ADD greek_f CHAR(32) CHARACTER SET greek NOT NULL;
UPDATE t1 SET greek_f=CONVERT(ucs2_f USING greek) WHERE comment LIKE _latin2'GRE%';
UPDATE t1 SET armscii8_f=CONVERT(ucs2_f USING armscii8) WHERE comment LIKE _latin2'ARM%';
UPDATE t1 SET utf8_f=CONVERT(ucs2_f USING utf8) WHERE utf8_f=_utf8'';
UPDATE t1 SET ucs2_f=CONVERT(utf8_f USING ucs2) WHERE ucs2_f=_ucs2'';
SELECT comment, koi8_ru_f, utf8_f, hex(bin_f), ucs2_f, armscii8_f, greek_f FROM t1;
comment	koi8_ru_f	utf8_f	hex(bin_f)	ucs2_f	armscii8_f	greek_f
LAT SMALL A	a	a	61	a		
LAT SMALL B	b	b	62	b		
LAT SMALL C	c	c	63	c		
LAT SMALL D	d	d	64	d		
LAT SMALL E	e	e	65	e		
LAT SMALL F	f	f	66	f		
LAT SMALL G	g	g	67	g		
LAT SMALL H	h	h	68	h		
LAT SMALL I	i	i	69	i		
LAT SMALL J	j	j	6A	j		
LAT SMALL K	k	k	6B	k		
LAT SMALL L	l	l	6C	l		
LAT SMALL M	m	m	6D	m		
LAT SMALL N	n	n	6E	n		
LAT SMALL O	o	o	6F	o		
LAT SMALL P	p	p	70	p		
LAT SMALL Q	q	q	71	q		
LAT SMALL R	r	r	72	r		
LAT SMALL S	s	s	73	s		
LAT SMALL T	t	t	74	t		
LAT SMALL U	u	u	75	u		
LAT SMALL V	v	v	76	v		
LAT SMALL W	w	w	77	w		
LAT SMALL X	x	x	78	x		
LAT SMALL Y	y	y	79	y		
LAT SMALL Z	z	z	7A	z		
LAT CAPIT A	A	A	41	A		
LAT CAPIT B	B	B	42	B		
LAT CAPIT C	C	C	43	C		
LAT CAPIT D	D	D	44	D		
LAT CAPIT E	E	E	45	E		
LAT CAPIT F	F	F	46	F		
LAT CAPIT G	G	G	47	G		
LAT CAPIT H	H	H	48	H		
LAT CAPIT I	I	I	49	I		
LAT CAPIT J	J	J	4A	J		
LAT CAPIT K	K	K	4B	K		
LAT CAPIT L	L	L	4C	L		
LAT CAPIT M	M	M	4D	M		
LAT CAPIT N	N	N	4E	N		
LAT CAPIT O	O	O	4F	O		
LAT CAPIT P	P	P	50	P		
LAT CAPIT Q	Q	Q	51	Q		
LAT CAPIT R	R	R	52	R		
LAT CAPIT S	S	S	53	S		
LAT CAPIT T	T	T	54	T		
LAT CAPIT U	U	U	55	U		
LAT CAPIT V	V	V	56	V		
LAT CAPIT W	W	W	57	W		
LAT CAPIT X	X	X	58	X		
LAT CAPIT Y	Y	Y	59	Y		
LAT CAPIT Z	Z	Z	5A	Z		
CYR SMALL A	а	а	C1	а		
CYR SMALL BE	б	б	C2	б		
CYR SMALL VE	в	в	D7	в		
CYR SMALL GE	г	г	C7	г		
CYR SMALL DE	д	д	C4	д		
CYR SMALL IE	е	е	C5	е		
CYR SMALL IO	ё	ё	A3	ё		
CYR SMALL ZHE	ж	ж	D6	ж		
CYR SMALL ZE	з	з	DA	з		
CYR SMALL I	и	и	C9	и		
CYR SMALL KA	к	к	CB	к		
CYR SMALL EL	л	л	CC	л		
CYR SMALL EM	м	м	CD	м		
CYR SMALL EN	н	н	CE	н		
CYR SMALL O	о	о	CF	о		
CYR SMALL PE	п	п	D0	п		
CYR SMALL ER	р	р	D2	р		
CYR SMALL ES	с	с	D3	с		
CYR SMALL TE	т	т	D4	т		
CYR SMALL U	у	у	D5	у		
CYR SMALL EF	ф	ф	C6	ф		
CYR SMALL HA	х	х	C8	х		
CYR SMALL TSE	ц	ц	C3	ц		
CYR SMALL CHE	ч	ч	DE	ч		
CYR SMALL SHA	ш	ш	DB	ш		
CYR SMALL SCHA	щ	щ	DD	щ		
CYR SMALL HARD SIGN	ъ	ъ	DF	ъ		
CYR SMALL YERU	ы	ы	D9	ы		
CYR SMALL SOFT SIGN	ь	ь	D8	ь		
CYR SMALL E	э	э	DC	э		
CYR SMALL YU	ю	ю	C0	ю		
CYR SMALL YA	я	я	D1	я		
CYR CAPIT A	А	А	E1	А		
CYR CAPIT BE	Б	Б	E2	Б		
CYR CAPIT VE	В	В	F7	В		
CYR CAPIT GE	Г	Г	E7	Г		
CYR CAPIT DE	Д	Д	E4	Д		
CYR CAPIT IE	Е	Е	E5	Е		
CYR CAPIT IO	Ё	Ё	B3	Ё		
CYR CAPIT ZHE	Ж	Ж	F6	Ж		
CYR CAPIT ZE	З	З	FA	З		
CYR CAPIT I	И	И	E9	И		
CYR CAPIT KA	К	К	EB	К		
CYR CAPIT EL	Л	Л	EC	Л		
CYR CAPIT EM	М	М	ED	М		
CYR CAPIT EN	Н	Н	EE	Н		
CYR CAPIT O	О	О	EF	О		
CYR CAPIT PE	П	П	F0	П		
CYR CAPIT ER	Р	Р	F2	Р		
CYR CAPIT ES	С	С	F3	С		
CYR CAPIT TE	Т	Т	F4	Т		
CYR CAPIT U	У	У	F5	У		
CYR CAPIT EF	Ф	Ф	E6	Ф		
CYR CAPIT HA	Х	Х	E8	Х		
CYR CAPIT TSE	Ц	Ц	E3	Ц		
CYR CAPIT CHE	Ч	Ч	FE	Ч		
CYR CAPIT SHA	Ш	Ш	FB	Ш		
CYR CAPIT SCHA	Щ	Щ	FD	Щ		
CYR CAPIT HARD SIGN	Ъ	Ъ	FF	Ъ		
CYR CAPIT YERU	Ы	Ы	F9	Ы		
CYR CAPIT SOFT SIGN	Ь	Ь	F8	Ь		
CYR CAPIT E	Э	Э	FC	Э		
CYR CAPIT YU	Ю	Ю	E0	Ю		
CYR CAPIT YA	Я	Я	F1	Я		
GREEK CAPIT ALPHA		Α	00	Α		Α
GREEK CAPIT BETA		Β	00	Β		Β
GREEK CAPIT GAMMA		Γ	00	Γ		Γ
GREEK CAPIT DELTA		Δ	00	Δ		Δ
GREEK CAPIT EPSILON		Ε	00	Ε		Ε
GREEK SMALL ALPHA		α	00	α		α
GREEK SMALL BETA		β	00	β		β
GREEK SMALL GAMMA		γ	00	γ		γ
GREEK SMALL DELTA		δ	00	δ		δ
GREEK SMALL EPSILON		ε	00	ε		ε
ARMENIAN CAPIT AYB		Ա	00	Ա	Ա	
ARMENIAN CAPIT BEN		Բ	00	Բ	Բ	
ARMENIAN CAPIT GIM		Գ	00	Գ	Գ	
ARMENIAN CAPIT DA		Դ	00	Դ	Դ	
ARMENIAN CAPIT ECH		Ե	00	Ե	Ե	
ARMENIAN CAPIT ZA		Զ	00	Զ	Զ	
ARMENIAN SMALL YAB		ա	00	ա	ա	
ARMENIAN SMALL BEN		բ	00	բ	բ	
ARMENIAN SMALL GIM		գ	00	գ	գ	
ARMENIAN SMALL DA		դ	00	դ	դ	
ARMENIAN SMALL ECH		ե	00	ե	ե	
ARMENIAN SMALL ZA		զ	00	զ	զ	
SET CHARACTER SET 'binary';
SELECT * FROM t1;
comment	koi8_ru_f	utf8_f	bin_f	ucs2_f	armscii8_f	greek_f
LAT SMALL A	a	a	a	a		
LAT SMALL B	b	b	b	b		
LAT SMALL C	c	c	c	c		
LAT SMALL D	d	d	d	d		
LAT SMALL E	e	e	e	e		
LAT SMALL F	f	f	f	f		
LAT SMALL G	g	g	g	g		
LAT SMALL H	h	h	h	h		
LAT SMALL I	i	i	i	i		
LAT SMALL J	j	j	j	j		
LAT SMALL K	k	k	k	k		
LAT SMALL L	l	l	l	l		
LAT SMALL M	m	m	m	m		
LAT SMALL N	n	n	n	n		
LAT SMALL O	o	o	o	o		
LAT SMALL P	p	p	p	p		
LAT SMALL Q	q	q	q	q		
LAT SMALL R	r	r	r	r		
LAT SMALL S	s	s	s	s		
LAT SMALL T	t	t	t	t		
LAT SMALL U	u	u	u	u		
LAT SMALL V	v	v	v	v		
LAT SMALL W	w	w	w	w		
LAT SMALL X	x	x	x	x		
LAT SMALL Y	y	y	y	y		
LAT SMALL Z	z	z	z	z		
LAT CAPIT A	A	A	A	A		
LAT CAPIT B	B	B	B	B		
LAT CAPIT C	C	C	C	C		
LAT CAPIT D	D	D	D	D		
LAT CAPIT E	E	E	E	E		
LAT CAPIT F	F	F	F	F		
LAT CAPIT G	G	G	G	G		
LAT CAPIT H	H	H	H	H		
LAT CAPIT I	I	I	I	I		
LAT CAPIT J	J	J	J	J		
LAT CAPIT K	K	K	K	K		
LAT CAPIT L	L	L	L	L		
LAT CAPIT M	M	M	M	M		
LAT CAPIT N	N	N	N	N		
LAT CAPIT O	O	O	O	O		
LAT CAPIT P	P	P	P	P		
LAT CAPIT Q	Q	Q	Q	Q		
LAT CAPIT R	R	R	R	R		
LAT CAPIT S	S	S	S	S		
LAT CAPIT T	T	T	T	T		
LAT CAPIT U	U	U	U	U		
LAT CAPIT V	V	V	V	V		
LAT CAPIT W	W	W	W	W		
LAT CAPIT X	X	X	X	X		
LAT CAPIT Y	Y	Y	Y	Y		
LAT CAPIT Z	Z	Z	Z	Z		
CYR SMALL A	�	а	�	0		
CYR SMALL BE	�	б	�	1		
CYR SMALL VE	�	в	�	2		
CYR SMALL GE	�	г	�	3		
CYR SMALL DE	�	д	�	4		
CYR SMALL IE	�	е	�	5		
CYR SMALL IO	�	ё	�	Q		
CYR SMALL ZHE	�	ж	�	6		
CYR SMALL ZE	�	з	�	7		
CYR SMALL I	�	и	�	8		
CYR SMALL KA	�	к	�	:		
CYR SMALL EL	�	л	�	;		
CYR SMALL EM	�	м	�	<		
CYR SMALL EN	�	н	�	=		
CYR SMALL O	�	о	�	>		
CYR SMALL PE	�	п	�	?		
CYR SMALL ER	�	р	�	@		
CYR SMALL ES	�	с	�	A		
CYR SMALL TE	�	т	�	B		
CYR SMALL U	�	у	�	C		
CYR SMALL EF	�	ф	�	D		
CYR SMALL HA	�	х	�	E		
CYR SMALL TSE	�	ц	�	F		
CYR SMALL CHE	�	ч	�	G		
CYR SMALL SHA	�	ш	�	H		
CYR SMALL SCHA	�	щ	�	I		
CYR SMALL HARD SIGN	�	ъ	�	J		
CYR SMALL YERU	�	ы	�	K		
CYR SMALL SOFT SIGN	�	ь	�	L		
CYR SMALL E	�	э	�	M		
CYR SMALL YU	�	ю	�	N		
CYR SMALL YA	�	я	�	O		
CYR CAPIT A	�	А	�			
CYR CAPIT BE	�	Б	�			
CYR CAPIT VE	�	В	�			
CYR CAPIT GE	�	Г	�			
CYR CAPIT DE	�	Д	�			
CYR CAPIT IE	�	Е	�			
CYR CAPIT IO	�	Ё	�	
		
CYR CAPIT ZHE	�	Ж	�			
CYR CAPIT ZE	�	З	�			
CYR CAPIT I	�	И	�			
CYR CAPIT KA	�	К	�			
CYR CAPIT EL	�	Л	�			
CYR CAPIT EM	�	М	�			
CYR CAPIT EN	�	Н	�			
CYR CAPIT O	�	О	�			
CYR CAPIT PE	�	П	�			
CYR CAPIT ER	�	Р	�	 		
CYR CAPIT ES	�	С	�	!		
CYR CAPIT TE	�	Т	�	"		
CYR CAPIT U	�	У	�	#		
CYR CAPIT EF	�	Ф	�	$		
CYR CAPIT HA	�	Х	�	%		
CYR CAPIT TSE	�	Ц	�	&		
CYR CAPIT CHE	�	Ч	�	'		
CYR CAPIT SHA	�	Ш	�	(		
CYR CAPIT SCHA	�	Щ	�	)		
CYR CAPIT HARD SIGN	�	Ъ	�	*		
CYR CAPIT YERU	�	Ы	�	+		
CYR CAPIT SOFT SIGN	�	Ь	�	,		
CYR CAPIT E	�	Э	�	-		
CYR CAPIT YU	�	Ю	�	.		
CYR CAPIT YA	�	Я	�	/		
GREEK CAPIT ALPHA		Α		�		�
GREEK CAPIT BETA		Β		�		�
GREEK CAPIT GAMMA		Γ		�		�
GREEK CAPIT DELTA		Δ		�		�
GREEK CAPIT EPSILON		Ε		�		�
GREEK SMALL ALPHA		α		�		�
GREEK SMALL BETA		β		�		�
GREEK SMALL GAMMA		γ		�		�
GREEK SMALL DELTA		δ		�		�
GREEK SMALL EPSILON		ε		�		�
ARMENIAN CAPIT AYB		Ա		1	�	
ARMENIAN CAPIT BEN		Բ		2	�	
ARMENIAN CAPIT GIM		Գ		3	�	
ARMENIAN CAPIT DA		Դ		4	�	
ARMENIAN CAPIT ECH		Ե		5	�	
ARMENIAN CAPIT ZA		Զ		6	�	
ARMENIAN SMALL YAB		ա		a	�	
ARMENIAN SMALL BEN		բ		b	�	
ARMENIAN SMALL GIM		գ		c	�	
ARMENIAN SMALL DA		դ		d	�	
ARMENIAN SMALL ECH		ե		e	�	
ARMENIAN SMALL ZA		զ		f	�	
SELECT min(comment),count(*) FROM t1 GROUP BY ucs2_f;
min(comment)	count(*)
LAT CAPIT A	2
LAT CAPIT B	2
LAT CAPIT C	2
LAT CAPIT D	2
LAT CAPIT E	2
LAT CAPIT F	2
LAT CAPIT G	2
LAT CAPIT H	2
LAT CAPIT I	2
LAT CAPIT J	2
LAT CAPIT K	2
LAT CAPIT L	2
LAT CAPIT M	2
LAT CAPIT N	2
LAT CAPIT O	2
LAT CAPIT P	2
LAT CAPIT Q	2
LAT CAPIT R	2
LAT CAPIT S	2
LAT CAPIT T	2
LAT CAPIT U	2
LAT CAPIT V	2
LAT CAPIT W	2
LAT CAPIT X	2
LAT CAPIT Y	2
LAT CAPIT Z	2
GREEK CAPIT ALPHA	2
GREEK CAPIT BETA	2
GREEK CAPIT GAMMA	2
GREEK CAPIT DELTA	2
GREEK CAPIT EPSILON	2
CYR CAPIT A	2
CYR CAPIT BE	2
CYR CAPIT VE	2
CYR CAPIT GE	2
CYR CAPIT DE	2
CYR CAPIT IE	4
CYR CAPIT ZHE	2
CYR CAPIT ZE	2
CYR CAPIT I	2
CYR CAPIT KA	2
CYR CAPIT EL	2
CYR CAPIT EM	2
CYR CAPIT EN	2
CYR CAPIT O	2
CYR CAPIT PE	2
CYR CAPIT ER	2
CYR CAPIT ES	2
CYR CAPIT TE	2
CYR CAPIT U	2
CYR CAPIT EF	2
CYR CAPIT HA	2
CYR CAPIT TSE	2
CYR CAPIT CHE	2
CYR CAPIT SHA	2
CYR CAPIT SCHA	2
CYR CAPIT HARD SIGN	2
CYR CAPIT YERU	2
CYR CAPIT SOFT SIGN	2
CYR CAPIT E	2
CYR CAPIT YU	2
CYR CAPIT YA	2
ARMENIAN CAPIT AYB	2
ARMENIAN CAPIT BEN	2
ARMENIAN CAPIT GIM	2
ARMENIAN CAPIT DA	2
ARMENIAN CAPIT ECH	2
ARMENIAN CAPIT ZA	2
DROP TABLE t1;
#
# Start of 5.1 tests
#
#
# Bug#58371 Assertion failed: !s.uses_buffer_owned_by(this) with format string function
#
SET NAMES latin1;
DO CONVERT(CAST(SUBSTRING_INDEX(FORMAT(1,'1111'), FORMAT('','Zpq'),1) 
AS BINARY(0)) USING utf8);
Warnings:
Warning	1292	Truncated incorrect INTEGER value: 'Zpq'
Warning	1292	Truncated incorrect INTEGER value: 'Zpq'
Warning	1292	Truncated incorrect DOUBLE value: ''
Warning	1292	Truncated incorrect BINARY(0) value: '1.'
#
# End of 5.1 tests
#
#
# Start of 5.5 tests
#
#
# WL#1213 Implement 4-byte UTF8, UTF16 and UTF32
# Testing that only utf8mb4 is superset for utf8
# No other Unicode character set pairs have superset/subset relations
#
CREATE TABLE t1 (
utf8 CHAR CHARACTER SET utf8,
utf8mb4 CHAR CHARACTER SET utf8mb4,
ucs2 CHAR CHARACTER SET ucs2,
utf16 CHAR CHARACTER SET utf16,
utf32 CHAR CHARACTER SET utf32
);
INSERT INTO t1 VALUES ('','','','','');
SELECT CHARSET(CONCAT(utf8, utf8mb4)) FROM t1;
CHARSET(CONCAT(utf8, utf8mb4))
utf8mb4
SELECT CHARSET(CONCAT(utf8, ucs2)) FROM t1;
ERROR HY000: Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (ucs2_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf8, utf16)) FROM t1;
ERROR HY000: Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf16_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf8, utf32)) FROM t1;
ERROR HY000: Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf32_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf8mb4, utf8)) FROM t1;
CHARSET(CONCAT(utf8mb4, utf8))
utf8mb4
SELECT CHARSET(CONCAT(utf8mb4, ucs2)) FROM t1;
ERROR HY000: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (ucs2_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf8mb4, utf16)) FROM t1;
ERROR HY000: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf16_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf8mb4, utf32)) FROM t1;
ERROR HY000: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf32_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(ucs2, utf8)) FROM t1;
ERROR HY000: Illegal mix of collations (ucs2_general_ci,IMPLICIT) and (utf8mb3_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(ucs2, utf8mb4)) FROM t1;
ERROR HY000: Illegal mix of collations (ucs2_general_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(ucs2, utf16)) FROM t1;
ERROR HY000: Illegal mix of collations (ucs2_general_ci,IMPLICIT) and (utf16_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(ucs2, utf32)) FROM t1;
ERROR HY000: Illegal mix of collations (ucs2_general_ci,IMPLICIT) and (utf32_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf16, utf8)) FROM t1;
ERROR HY000: Illegal mix of collations (utf16_general_ci,IMPLICIT) and (utf8mb3_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf16, ucs2)) FROM t1;
ERROR HY000: Illegal mix of collations (utf16_general_ci,IMPLICIT) and (ucs2_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf16, utf8mb4)) FROM t1;
ERROR HY000: Illegal mix of collations (utf16_general_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf16, utf32)) FROM t1;
ERROR HY000: Illegal mix of collations (utf16_general_ci,IMPLICIT) and (utf32_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf32, utf8)) FROM t1;
ERROR HY000: Illegal mix of collations (utf32_general_ci,IMPLICIT) and (utf8mb3_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf32, ucs2)) FROM t1;
ERROR HY000: Illegal mix of collations (utf32_general_ci,IMPLICIT) and (ucs2_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf32, utf8mb4)) FROM t1;
ERROR HY000: Illegal mix of collations (utf32_general_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation 'concat'
SELECT CHARSET(CONCAT(utf32, utf16)) FROM t1;
ERROR HY000: Illegal mix of collations (utf32_general_ci,IMPLICIT) and (utf16_general_ci,IMPLICIT) for operation 'concat'
DROP TABLE t1;
#
# Bug#58321 No warning when characters outside BMP0 is converted to UCS2
#
CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf32);
CREATE TABLE t2 (a VARCHAR(10) CHARACTER SET ucs2);
INSERT INTO t1 VALUES (0x10082), (0x12345);
INSERT IGNORE INTO t2 SELECT * FROM t1;
Warnings:
Warning	1366	Incorrect string value: '\x00\x01\x00\x82' for column `test`.`t2`.`a` at row 1
Warning	1366	Incorrect string value: '\x00\x01\x23\x45' for column `test`.`t2`.`a` at row 2
SELECT HEX(a) FROM t2;
HEX(a)
003F
003F
DROP TABLE t1;
DROP TABLE t2;
#
# End of 5.5 tests
#
#
# Bug#11766143 59185: ASSERTION FAILED: (FIXED == 1), FILE
# ITEM_STRFUNC.CC, LINE 2760
#
CREATE TABLE t1 (a CHAR(1) CHARSET UTF8);
INSERT INTO t1 VALUES ('a'), ('b');
CREATE TABLE t2 (a BINARY(1));
SELECT * FROM t2 WHERE a=(SELECT a FROM t1) AND a=_LATIN1'x';
ERROR 21000: Subquery returns more than 1 row
DROP TABLE t2;
DROP TABLE t1;
#
# Start of 10.1 tests
#
#
# MDEV-8362 dash '-' is not recognized in charset armscii8 on select where query
#
CREATE TABLE t1 (a VARCHAR(64) CHARACTER SET armscii8);
INSERT INTO t1 VALUES ('abc-def');
SELECT * FROM t1 WHERE a='abc-def';
a
abc-def
SELECT * FROM t1 WHERE a LIKE 'abc%';
a
abc-def
DROP TABLE t1;
SELECT HEX(CONVERT(_utf8 0x2728292C2D2E USING armscii8));
HEX(CONVERT(_utf8 0x2728292C2D2E USING armscii8))
2728292C2D2E
#
# End of 10.1 tests
#