summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <bar@bar.mysql.r18.ru>2003-03-17 22:00:03 +0400
committerunknown <bar@bar.mysql.r18.ru>2003-03-17 22:00:03 +0400
commitac4547236720ac0da80e322dadf83393cb431064 (patch)
treeb32f699d2af412aec2d434d1b10d24547e8904bf /mysql-test
parent84f0e1172981750a85bae8090548784f0aefa1e2 (diff)
downloadmariadb-git-ac4547236720ac0da80e322dadf83393cb431064.tar.gz
.del-ctype_many.result~9b541c4def2b5afb:
Delete: mysql-test/r/ctype_many.result I could not commit it, bk told it can't apply binary delta for textual file. BitKeeper/deleted/.del-ctype_many.result~9b541c4def2b5afb: Delete: mysql-test/r/ctype_many.result
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/ctype_many.result1399
1 files changed, 0 insertions, 1399 deletions
diff --git a/mysql-test/r/ctype_many.result b/mysql-test/r/ctype_many.result
deleted file mode 100644
index 0bbb0073420..00000000000
--- a/mysql-test/r/ctype_many.result
+++ /dev/null
@@ -1,1399 +0,0 @@
-DROP TABLE IF EXISTS t1;
-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');
-SELECT CONVERT(koi8_ru_f USING utf8),MIN(comment),COUNT(*) FROM t1 GROUP BY 1;
-CONVERT(koi8_ru_f USING utf8) 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 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
-ALTER TABLE t1 ADD utf8_f CHAR(32) CHARACTER SET utf8 NOT NULL;
-UPDATE t1 SET utf8_f=CONVERT(koi8_ru_f USING utf8);
-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
-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 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;