ctype_many.result:

  new file

  As far as bk could not apply delta,
  I removed it.  Now I'm adding the
  new version into the tree again.

1 files changed, 1685 insertions, 0 deletions

diff --git a/mysql-test/r/ctype_many.result b/mysql-test/r/ctype_many.result
new file mode 100644
index 00000000000..096ddf8188b
--- /dev/null
+++ b/mysql-test/r/ctype_many.result
@@ -0,0 +1,1685 @@
+DROP TABLE IF EXISTS t1;
+SET NAMES latin1;
+CREATE TABLE t1 (
+comment CHAR(32) ASCII NOT NULL,
+koi8_ru_f CHAR(32) CHARACTER SET koi8r NOT NULL
+) CHARSET=latin5;
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `comment` char(32) character set latin1 NOT NULL default '',
+  `koi8_ru_f` char(32) character set koi8r NOT NULL default ''
+) TYPE=MyISAM CHARSET=latin5
+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 NOT NULL default '',
+  `koi8_ru_f` char(32) character set koi8r NOT NULL default ''
+) TYPE=MyISAM CHARSET=latin5
+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 NOT NULL default '',
+  `koi8_ru_f` char(32) character set koi8r NOT NULL default '',
+  `latin5_f` char(32) NOT NULL default ''
+) TYPE=MyISAM CHARSET=latin5
+ALTER TABLE t1 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 default '',
+  `koi8_ru_f` char(32) character set koi8r NOT NULL default '',
+  `latin5_f` char(32) character set latin5 NOT NULL default '',
+  `latin2_f` char(32) NOT NULL default ''
+) TYPE=MyISAM CHARSET=latin2
+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 default '',
+  `koi8_ru_f` char(32) character set koi8r NOT NULL default ''
+) TYPE=MyISAM CHARSET=latin2
+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 NAMES 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;
+UPDATE t1 SET utf8_f=CONVERT(koi8_ru_f USING utf8);
+SET NAMES 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(32) BYTE NOT NULL;
+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 NAMES utf8;
+ALTER TABLE t1 ADD ucs2_f CHAR(32) CHARACTER SET ucs2;
+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 'GRE%';
+UPDATE t1 SET armscii8_f=CONVERT(ucs2_f USING armscii8) WHERE comment LIKE 'ARM%';
+UPDATE t1 SET utf8_f=CONVERT(ucs2_f USING utf8) WHERE utf8_f='';
+UPDATE t1 SET ucs2_f=CONVERT(utf8_f USING ucs2) WHERE ucs2_f='';
+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	а	а	�	а		
+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	Я	Я	�	Я		
+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		Ա		Ա	Ա	
+ARMENIAN CAPIT BEN		Բ		Բ	Բ	
+ARMENIAN CAPIT GIM		Գ		Գ	Գ	
+ARMENIAN CAPIT DA		Դ		Դ	Դ	
+ARMENIAN CAPIT ECH		Ե		Ե	Ե	
+ARMENIAN CAPIT ZA		Զ		Զ	Զ	
+ARMENIAN SMALL YAB		ա		ա	ա	
+ARMENIAN SMALL BEN		բ		բ	բ	
+ARMENIAN SMALL GIM		գ		գ	գ	
+ARMENIAN SMALL DA		դ		դ	դ	
+ARMENIAN SMALL ECH		ե		ե	ե	
+ARMENIAN SMALL ZA		զ		զ	զ	
+SET NAMES 'binary';
+SELECT * FROM t1;
+comment	koi8_ru_f	utf8_f	bin_f	ucs2_f	armscii8_f	greek_f
+LAT SMALL A	a	a	a	
+LAT SMALL B	b	b	b	
+LAT SMALL C	c	c	c	
+LAT SMALL D	d	d	d	
+LAT SMALL E	e	e	e	
+LAT SMALL F	f	f	f	
+LAT SMALL G	g	g	g	
+LAT SMALL H	h	h	h	
+LAT SMALL I	i	i	i	
+LAT SMALL J	j	j	j	
+LAT SMALL K	k	k	k	
+LAT SMALL L	l	l	l	
+LAT SMALL M	m	m	m	
+LAT SMALL N	n	n	n	
+LAT SMALL O	o	o	o	
+LAT SMALL P	p	p	p	
+LAT SMALL Q	q	q	q	
+LAT SMALL R	r	r	r	
+LAT SMALL S	s	s	s	
+LAT SMALL T	t	t	t	
+LAT SMALL U	u	u	u	
+LAT SMALL V	v	v	v	
+LAT SMALL W	w	w	w	
+LAT SMALL X	x	x	x	
+LAT SMALL Y	y	y	y	
+LAT SMALL Z	z	z	z	
+LAT CAPIT A	A	A	A	
+LAT CAPIT B	B	B	B	
+LAT CAPIT C	C	C	C	
+LAT CAPIT D	D	D	D	
+LAT CAPIT E	E	E	E	
+LAT CAPIT F	F	F	F	
+LAT CAPIT G	G	G	G	
+LAT CAPIT H	H	H	H	
+LAT CAPIT I	I	I	I	
+LAT CAPIT J	J	J	J	
+LAT CAPIT K	K	K	K	
+LAT CAPIT L	L	L	L	
+LAT CAPIT M	M	M	M	
+LAT CAPIT N	N	N	N	
+LAT CAPIT O	O	O	O	
+LAT CAPIT P	P	P	P	
+LAT CAPIT Q	Q	Q	Q	
+LAT CAPIT R	R	R	R	
+LAT CAPIT S	S	S	S	
+LAT CAPIT T	T	T	T	
+LAT CAPIT U	U	U	U	
+LAT CAPIT V	V	V	V	
+LAT CAPIT W	W	W	W	
+LAT CAPIT X	X	X	X	
+LAT CAPIT Y	Y	Y	Y	
+LAT CAPIT 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;