diff options
author | unknown <bar@bar.mysql.r18.ru> | 2003-03-17 22:00:03 +0400 |
---|---|---|
committer | unknown <bar@bar.mysql.r18.ru> | 2003-03-17 22:00:03 +0400 |
commit | ac4547236720ac0da80e322dadf83393cb431064 (patch) | |
tree | b32f699d2af412aec2d434d1b10d24547e8904bf /mysql-test | |
parent | 84f0e1172981750a85bae8090548784f0aefa1e2 (diff) | |
download | mariadb-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.result | 1399 |
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; |