1DROP TABLE IF EXISTS t1; 2DROP VIEW IF EXISTS v1; 3CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a VARBINARY(32)); 4INSERT INTO t1 (a) VALUES (''),('_'),('%'),('\_'),('\%'),('\\'); 5INSERT INTO t1 (a) VALUES ('a'),('c'); 6INSERT INTO t1 (a) VALUES ('a_'),('c_'); 7INSERT INTO t1 (a) VALUES ('a%'),('c%'); 8INSERT INTO t1 (a) VALUES ('aa'),('cc'),('ch'); 9INSERT INTO t1 (a) VALUES ('aa_'),('cc_'),('ch_'); 10INSERT INTO t1 (a) VALUES ('aa%'),('cc%'),('ch%'); 11INSERT INTO t1 (a) VALUES ('aaa'),('ccc'),('cch'); 12INSERT INTO t1 (a) VALUES ('aaa_'),('ccc_'),('cch_'); 13INSERT INTO t1 (a) VALUES ('aaa%'),('ccc%'),('cch%'); 14INSERT INTO t1 (a) VALUES ('aaaaaaaaaaaaaaaaaaaa'); 15INSERT INTO t1 (a) VALUES ('caaaaaaaaaaaaaaaaaaa'); 16CREATE VIEW v1 AS 17SELECT id, 'a' AS name, a AS val FROM t1 18UNION 19SELECT id, 'mn', HEX(LIKE_RANGE_MIN(a, 16)) AS min FROM t1 20UNION 21SELECT id, 'mx', HEX(LIKE_RANGE_MAX(a, 16)) AS max FROM t1 22UNION 23SELECT id, 'sp', REPEAT('-', 32) AS sep FROM t1 24ORDER BY id, name; 25SELECT * FROM v1; 26id name val 271 a 281 mn 291 mx 301 sp -------------------------------- 312 a _ 322 mn 00 332 mx FF 342 sp -------------------------------- 353 a % 363 mn 373 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 383 sp -------------------------------- 394 a \_ 404 mn 5F 414 mx 5F 424 sp -------------------------------- 435 a \% 445 mn 25 455 mx 25 465 sp -------------------------------- 476 a \ 486 mn 5C 496 mx 5C 506 sp -------------------------------- 517 a a 527 mn 61 537 mx 61 547 sp -------------------------------- 558 a c 568 mn 63 578 mx 63 588 sp -------------------------------- 599 a a_ 609 mn 6100 619 mx 61FF 629 sp -------------------------------- 6310 a c_ 6410 mn 6300 6510 mx 63FF 6610 sp -------------------------------- 6711 a a% 6811 mn 61 6911 mx 61FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 7011 sp -------------------------------- 7112 a c% 7212 mn 63 7312 mx 63FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 7412 sp -------------------------------- 7513 a aa 7613 mn 6161 7713 mx 6161 7813 sp -------------------------------- 7914 a cc 8014 mn 6363 8114 mx 6363 8214 sp -------------------------------- 8315 a ch 8415 mn 6368 8515 mx 6368 8615 sp -------------------------------- 8716 a aa_ 8816 mn 616100 8916 mx 6161FF 9016 sp -------------------------------- 9117 a cc_ 9217 mn 636300 9317 mx 6363FF 9417 sp -------------------------------- 9518 a ch_ 9618 mn 636800 9718 mx 6368FF 9818 sp -------------------------------- 9919 a aa% 10019 mn 6161 10119 mx 6161FFFFFFFFFFFFFFFFFFFFFFFFFFFF 10219 sp -------------------------------- 10320 a cc% 10420 mn 6363 10520 mx 6363FFFFFFFFFFFFFFFFFFFFFFFFFFFF 10620 sp -------------------------------- 10721 a ch% 10821 mn 6368 10921 mx 6368FFFFFFFFFFFFFFFFFFFFFFFFFFFF 11021 sp -------------------------------- 11122 a aaa 11222 mn 616161 11322 mx 616161 11422 sp -------------------------------- 11523 a ccc 11623 mn 636363 11723 mx 636363 11823 sp -------------------------------- 11924 a cch 12024 mn 636368 12124 mx 636368 12224 sp -------------------------------- 12325 a aaa_ 12425 mn 61616100 12525 mx 616161FF 12625 sp -------------------------------- 12726 a ccc_ 12826 mn 63636300 12926 mx 636363FF 13026 sp -------------------------------- 13127 a cch_ 13227 mn 63636800 13327 mx 636368FF 13427 sp -------------------------------- 13528 a aaa% 13628 mn 616161 13728 mx 616161FFFFFFFFFFFFFFFFFFFFFFFFFF 13828 sp -------------------------------- 13929 a ccc% 14029 mn 636363 14129 mx 636363FFFFFFFFFFFFFFFFFFFFFFFFFF 14229 sp -------------------------------- 14330 a cch% 14430 mn 636368 14530 mx 636368FFFFFFFFFFFFFFFFFFFFFFFFFF 14630 sp -------------------------------- 14731 a aaaaaaaaaaaaaaaaaaaa 14831 mn 61616161616161616161616161616161 14931 mx 61616161616161616161616161616161 15031 sp -------------------------------- 15132 a caaaaaaaaaaaaaaaaaaa 15232 mn 63616161616161616161616161616161 15332 mx 63616161616161616161616161616161 15432 sp -------------------------------- 155ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET latin1; 156SELECT * FROM v1; 157id name val 1581 a 1591 mn 1601 mx 1611 sp -------------------------------- 1622 a _ 1632 mn 00 1642 mx FF 1652 sp -------------------------------- 1663 a % 1673 mn 00000000000000000000000000000000 1683 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 1693 sp -------------------------------- 1704 a \_ 1714 mn 5F 1724 mx 5F 1734 sp -------------------------------- 1745 a \% 1755 mn 25 1765 mx 25 1775 sp -------------------------------- 1786 a \ 1796 mn 5C 1806 mx 5C 1816 sp -------------------------------- 1827 a a 1837 mn 61 1847 mx 61 1857 sp -------------------------------- 1868 a c 1878 mn 63 1888 mx 63 1898 sp -------------------------------- 1909 a a_ 1919 mn 6100 1929 mx 61FF 1939 sp -------------------------------- 19410 a c_ 19510 mn 6300 19610 mx 63FF 19710 sp -------------------------------- 19811 a a% 19911 mn 61000000000000000000000000000000 20011 mx 61FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 20111 sp -------------------------------- 20212 a c% 20312 mn 63000000000000000000000000000000 20412 mx 63FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 20512 sp -------------------------------- 20613 a aa 20713 mn 6161 20813 mx 6161 20913 sp -------------------------------- 21014 a cc 21114 mn 6363 21214 mx 6363 21314 sp -------------------------------- 21415 a ch 21515 mn 6368 21615 mx 6368 21715 sp -------------------------------- 21816 a aa_ 21916 mn 616100 22016 mx 6161FF 22116 sp -------------------------------- 22217 a cc_ 22317 mn 636300 22417 mx 6363FF 22517 sp -------------------------------- 22618 a ch_ 22718 mn 636800 22818 mx 6368FF 22918 sp -------------------------------- 23019 a aa% 23119 mn 61610000000000000000000000000000 23219 mx 6161FFFFFFFFFFFFFFFFFFFFFFFFFFFF 23319 sp -------------------------------- 23420 a cc% 23520 mn 63630000000000000000000000000000 23620 mx 6363FFFFFFFFFFFFFFFFFFFFFFFFFFFF 23720 sp -------------------------------- 23821 a ch% 23921 mn 63680000000000000000000000000000 24021 mx 6368FFFFFFFFFFFFFFFFFFFFFFFFFFFF 24121 sp -------------------------------- 24222 a aaa 24322 mn 616161 24422 mx 616161 24522 sp -------------------------------- 24623 a ccc 24723 mn 636363 24823 mx 636363 24923 sp -------------------------------- 25024 a cch 25124 mn 636368 25224 mx 636368 25324 sp -------------------------------- 25425 a aaa_ 25525 mn 61616100 25625 mx 616161FF 25725 sp -------------------------------- 25826 a ccc_ 25926 mn 63636300 26026 mx 636363FF 26126 sp -------------------------------- 26227 a cch_ 26327 mn 63636800 26427 mx 636368FF 26527 sp -------------------------------- 26628 a aaa% 26728 mn 61616100000000000000000000000000 26828 mx 616161FFFFFFFFFFFFFFFFFFFFFFFFFF 26928 sp -------------------------------- 27029 a ccc% 27129 mn 63636300000000000000000000000000 27229 mx 636363FFFFFFFFFFFFFFFFFFFFFFFFFF 27329 sp -------------------------------- 27430 a cch% 27530 mn 63636800000000000000000000000000 27630 mx 636368FFFFFFFFFFFFFFFFFFFFFFFFFF 27730 sp -------------------------------- 27831 a aaaaaaaaaaaaaaaaaaaa 27931 mn 61616161616161616161616161616161 28031 mx 61616161616161616161616161616161 28131 sp -------------------------------- 28232 a caaaaaaaaaaaaaaaaaaa 28332 mn 63616161616161616161616161616161 28432 mx 63616161616161616161616161616161 28532 sp -------------------------------- 286ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8; 287SELECT * FROM v1; 288id name val 2891 a 2901 mn 2911 mx 2921 sp -------------------------------- 2932 a _ 2942 mn 00000000000000000000000000000000 2952 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2962 sp -------------------------------- 2973 a % 2983 mn 00000000000000000000000000000000 2993 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3003 sp -------------------------------- 3014 a \_ 3024 mn 5F 3034 mx 5F 3044 sp -------------------------------- 3055 a \% 3065 mn 25 3075 mx 25 3085 sp -------------------------------- 3096 a \ 3106 mn 5C 3116 mx 5C 3126 sp -------------------------------- 3137 a a 3147 mn 61 3157 mx 61 3167 sp -------------------------------- 3178 a c 3188 mn 63 3198 mx 63 3208 sp -------------------------------- 3219 a a_ 3229 mn 61000000000000000000000000000000 3239 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 3249 sp -------------------------------- 32510 a c_ 32610 mn 63000000000000000000000000000000 32710 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 32810 sp -------------------------------- 32911 a a% 33011 mn 61000000000000000000000000000000 33111 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 33211 sp -------------------------------- 33312 a c% 33412 mn 63000000000000000000000000000000 33512 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 33612 sp -------------------------------- 33713 a aa 33813 mn 6161 33913 mx 6161 34013 sp -------------------------------- 34114 a cc 34214 mn 6363 34314 mx 6363 34414 sp -------------------------------- 34515 a ch 34615 mn 6368 34715 mx 6368 34815 sp -------------------------------- 34916 a aa_ 35016 mn 61610000000000000000000000000000 35116 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 35216 sp -------------------------------- 35317 a cc_ 35417 mn 63630000000000000000000000000000 35517 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 35617 sp -------------------------------- 35718 a ch_ 35818 mn 63680000000000000000000000000000 35918 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 36018 sp -------------------------------- 36119 a aa% 36219 mn 61610000000000000000000000000000 36319 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 36419 sp -------------------------------- 36520 a cc% 36620 mn 63630000000000000000000000000000 36720 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 36820 sp -------------------------------- 36921 a ch% 37021 mn 63680000000000000000000000000000 37121 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 37221 sp -------------------------------- 37322 a aaa 37422 mn 616161 37522 mx 616161 37622 sp -------------------------------- 37723 a ccc 37823 mn 636363 37923 mx 636363 38023 sp -------------------------------- 38124 a cch 38224 mn 636368 38324 mx 636368 38424 sp -------------------------------- 38525 a aaa_ 38625 mn 61616100000000000000000000000000 38725 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 38825 sp -------------------------------- 38926 a ccc_ 39026 mn 63636300000000000000000000000000 39126 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 39226 sp -------------------------------- 39327 a cch_ 39427 mn 63636800000000000000000000000000 39527 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 39627 sp -------------------------------- 39728 a aaa% 39828 mn 61616100000000000000000000000000 39928 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 40028 sp -------------------------------- 40129 a ccc% 40229 mn 63636300000000000000000000000000 40329 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 40429 sp -------------------------------- 40530 a cch% 40630 mn 63636800000000000000000000000000 40730 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 40830 sp -------------------------------- 40931 a aaaaaaaaaaaaaaaaaaaa 41031 mn 6161616161 41131 mx 6161616161 41231 sp -------------------------------- 41332 a caaaaaaaaaaaaaaaaaaa 41432 mn 6361616161 41532 mx 6361616161 41632 sp -------------------------------- 417ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci; 418SELECT * FROM v1; 419id name val 4201 a 4211 mn 4221 mx 4231 sp -------------------------------- 4242 a _ 4252 mn 09090909090909090909090909090909 4262 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 4272 sp -------------------------------- 4283 a % 4293 mn 09090909090909090909090909090909 4303 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 4313 sp -------------------------------- 4324 a \_ 4334 mn 5F 4344 mx 5F 4354 sp -------------------------------- 4365 a \% 4375 mn 25 4385 mx 25 4395 sp -------------------------------- 4406 a \ 4416 mn 5C 4426 mx 5C 4436 sp -------------------------------- 4447 a a 4457 mn 61 4467 mx 61 4477 sp -------------------------------- 4488 a c 4498 mn 63 4508 mx 63 4518 sp -------------------------------- 4529 a a_ 4539 mn 61090909090909090909090909090909 4549 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 4559 sp -------------------------------- 45610 a c_ 45710 mn 63090909090909090909090909090909 45810 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 45910 sp -------------------------------- 46011 a a% 46111 mn 61090909090909090909090909090909 46211 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 46311 sp -------------------------------- 46412 a c% 46512 mn 63090909090909090909090909090909 46612 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 46712 sp -------------------------------- 46813 a aa 46913 mn 6161 47013 mx 6161 47113 sp -------------------------------- 47214 a cc 47314 mn 6363 47414 mx 6363 47514 sp -------------------------------- 47615 a ch 47715 mn 6368 47815 mx 6368 47915 sp -------------------------------- 48016 a aa_ 48116 mn 61610909090909090909090909090909 48216 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 48316 sp -------------------------------- 48417 a cc_ 48517 mn 63630909090909090909090909090909 48617 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 48717 sp -------------------------------- 48818 a ch_ 48918 mn 63680909090909090909090909090909 49018 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 49118 sp -------------------------------- 49219 a aa% 49319 mn 61610909090909090909090909090909 49419 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 49519 sp -------------------------------- 49620 a cc% 49720 mn 63630909090909090909090909090909 49820 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 49920 sp -------------------------------- 50021 a ch% 50121 mn 63680909090909090909090909090909 50221 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 50321 sp -------------------------------- 50422 a aaa 50522 mn 616161 50622 mx 616161 50722 sp -------------------------------- 50823 a ccc 50923 mn 636363 51023 mx 636363 51123 sp -------------------------------- 51224 a cch 51324 mn 636368 51424 mx 636368 51524 sp -------------------------------- 51625 a aaa_ 51725 mn 61616109090909090909090909090909 51825 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 51925 sp -------------------------------- 52026 a ccc_ 52126 mn 63636309090909090909090909090909 52226 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 52326 sp -------------------------------- 52427 a cch_ 52527 mn 63636809090909090909090909090909 52627 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 52727 sp -------------------------------- 52828 a aaa% 52928 mn 61616109090909090909090909090909 53028 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 53128 sp -------------------------------- 53229 a ccc% 53329 mn 63636309090909090909090909090909 53429 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 53529 sp -------------------------------- 53630 a cch% 53730 mn 63636809090909090909090909090909 53830 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 53930 sp -------------------------------- 54031 a aaaaaaaaaaaaaaaaaaaa 54131 mn 6161616161 54231 mx 6161616161 54331 sp -------------------------------- 54432 a caaaaaaaaaaaaaaaaaaa 54532 mn 6361616161 54632 mx 6361616161 54732 sp -------------------------------- 548ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_czech_ci; 549SELECT * FROM v1; 550id name val 5511 a 5521 mn 5531 mx 5541 sp -------------------------------- 5552 a _ 5562 mn 09090909090909090909090909090909 5572 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 5582 sp -------------------------------- 5593 a % 5603 mn 09090909090909090909090909090909 5613 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 5623 sp -------------------------------- 5634 a \_ 5644 mn 5F 5654 mx 5F 5664 sp -------------------------------- 5675 a \% 5685 mn 25 5695 mx 25 5705 sp -------------------------------- 5716 a \ 5726 mn 5C 5736 mx 5C 5746 sp -------------------------------- 5757 a a 5767 mn 61 5777 mx 61 5787 sp -------------------------------- 5798 a c 5808 mn 63 5818 mx 63 5828 sp -------------------------------- 5839 a a_ 5849 mn 61090909090909090909090909090909 5859 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 5869 sp -------------------------------- 58710 a c_ 58810 mn 09090909090909090909090909090909 58910 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 59010 sp -------------------------------- 59111 a a% 59211 mn 61090909090909090909090909090909 59311 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 59411 sp -------------------------------- 59512 a c% 59612 mn 09090909090909090909090909090909 59712 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 59812 sp -------------------------------- 59913 a aa 60013 mn 6161 60113 mx 6161 60213 sp -------------------------------- 60314 a cc 60414 mn 6363 60514 mx 6363 60614 sp -------------------------------- 60715 a ch 60815 mn 6368 60915 mx 6368 61015 sp -------------------------------- 61116 a aa_ 61216 mn 61610909090909090909090909090909 61316 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 61416 sp -------------------------------- 61517 a cc_ 61617 mn 63090909090909090909090909090909 61717 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 61817 sp -------------------------------- 61918 a ch_ 62018 mn 63680909090909090909090909090909 62118 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 62218 sp -------------------------------- 62319 a aa% 62419 mn 61610909090909090909090909090909 62519 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 62619 sp -------------------------------- 62720 a cc% 62820 mn 63090909090909090909090909090909 62920 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 63020 sp -------------------------------- 63121 a ch% 63221 mn 63680909090909090909090909090909 63321 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 63421 sp -------------------------------- 63522 a aaa 63622 mn 616161 63722 mx 616161 63822 sp -------------------------------- 63923 a ccc 64023 mn 636363 64123 mx 636363 64223 sp -------------------------------- 64324 a cch 64424 mn 636368 64524 mx 636368 64624 sp -------------------------------- 64725 a aaa_ 64825 mn 61616109090909090909090909090909 64925 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 65025 sp -------------------------------- 65126 a ccc_ 65226 mn 63630909090909090909090909090909 65326 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 65426 sp -------------------------------- 65527 a cch_ 65627 mn 63636809090909090909090909090909 65727 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 65827 sp -------------------------------- 65928 a aaa% 66028 mn 61616109090909090909090909090909 66128 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 66228 sp -------------------------------- 66329 a ccc% 66429 mn 63630909090909090909090909090909 66529 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 66629 sp -------------------------------- 66730 a cch% 66830 mn 63636809090909090909090909090909 66930 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 67030 sp -------------------------------- 67131 a aaaaaaaaaaaaaaaaaaaa 67231 mn 6161616161 67331 mx 6161616161 67431 sp -------------------------------- 67532 a caaaaaaaaaaaaaaaaaaa 67632 mn 6361616161 67732 mx 6361616161 67832 sp -------------------------------- 679ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_danish_ci; 680SELECT * FROM v1; 681id name val 6821 a 6831 mn 6841 mx 6851 sp -------------------------------- 6862 a _ 6872 mn 09090909090909090909090909090909 6882 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 6892 sp -------------------------------- 6903 a % 6913 mn 09090909090909090909090909090909 6923 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 6933 sp -------------------------------- 6944 a \_ 6954 mn 5F 6964 mx 5F 6974 sp -------------------------------- 6985 a \% 6995 mn 25 7005 mx 25 7015 sp -------------------------------- 7026 a \ 7036 mn 5C 7046 mx 5C 7056 sp -------------------------------- 7067 a a 7077 mn 61 7087 mx 61 7097 sp -------------------------------- 7108 a c 7118 mn 63 7128 mx 63 7138 sp -------------------------------- 7149 a a_ 7159 mn 09090909090909090909090909090909 7169 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 7179 sp -------------------------------- 71810 a c_ 71910 mn 63090909090909090909090909090909 72010 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 72110 sp -------------------------------- 72211 a a% 72311 mn 09090909090909090909090909090909 72411 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 72511 sp -------------------------------- 72612 a c% 72712 mn 63090909090909090909090909090909 72812 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 72912 sp -------------------------------- 73013 a aa 73113 mn 6161 73213 mx 6161 73313 sp -------------------------------- 73414 a cc 73514 mn 6363 73614 mx 6363 73714 sp -------------------------------- 73815 a ch 73915 mn 6368 74015 mx 6368 74115 sp -------------------------------- 74216 a aa_ 74316 mn 61610909090909090909090909090909 74416 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 74516 sp -------------------------------- 74617 a cc_ 74717 mn 63630909090909090909090909090909 74817 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 74917 sp -------------------------------- 75018 a ch_ 75118 mn 63680909090909090909090909090909 75218 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 75318 sp -------------------------------- 75419 a aa% 75519 mn 61610909090909090909090909090909 75619 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 75719 sp -------------------------------- 75820 a cc% 75920 mn 63630909090909090909090909090909 76020 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 76120 sp -------------------------------- 76221 a ch% 76321 mn 63680909090909090909090909090909 76421 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 76521 sp -------------------------------- 76622 a aaa 76722 mn 616161 76822 mx 616161 76922 sp -------------------------------- 77023 a ccc 77123 mn 636363 77223 mx 636363 77323 sp -------------------------------- 77424 a cch 77524 mn 636368 77624 mx 636368 77724 sp -------------------------------- 77825 a aaa_ 77925 mn 61610909090909090909090909090909 78025 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 78125 sp -------------------------------- 78226 a ccc_ 78326 mn 63636309090909090909090909090909 78426 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 78526 sp -------------------------------- 78627 a cch_ 78727 mn 63636809090909090909090909090909 78827 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 78927 sp -------------------------------- 79028 a aaa% 79128 mn 61610909090909090909090909090909 79228 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 79328 sp -------------------------------- 79429 a ccc% 79529 mn 63636309090909090909090909090909 79629 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 79729 sp -------------------------------- 79830 a cch% 79930 mn 63636809090909090909090909090909 80030 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 80130 sp -------------------------------- 80231 a aaaaaaaaaaaaaaaaaaaa 80331 mn 61616161090909090909090909090909 80431 mx 61616161EFBFBFEFBFBFEFBFBFEFBFBF 80531 sp -------------------------------- 80632 a caaaaaaaaaaaaaaaaaaa 80732 mn 6361616161 80832 mx 6361616161 80932 sp -------------------------------- 810ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4; 811SELECT * FROM v1; 812id name val 8131 a 8141 mn 8151 mx 8161 sp -------------------------------- 8172 a _ 8182 mn 00000000000000000000000000000000 8192 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 8202 sp -------------------------------- 8213 a % 8223 mn 00000000000000000000000000000000 8233 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 8243 sp -------------------------------- 8254 a \_ 8264 mn 5F 8274 mx 5F 8284 sp -------------------------------- 8295 a \% 8305 mn 25 8315 mx 25 8325 sp -------------------------------- 8336 a \ 8346 mn 5C 8356 mx 5C 8366 sp -------------------------------- 8377 a a 8387 mn 61 8397 mx 61 8407 sp -------------------------------- 8418 a c 8428 mn 63 8438 mx 63 8448 sp -------------------------------- 8459 a a_ 8469 mn 61000000000000000000000000000000 8479 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 8489 sp -------------------------------- 84910 a c_ 85010 mn 63000000000000000000000000000000 85110 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 85210 sp -------------------------------- 85311 a a% 85411 mn 61000000000000000000000000000000 85511 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 85611 sp -------------------------------- 85712 a c% 85812 mn 63000000000000000000000000000000 85912 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 86012 sp -------------------------------- 86113 a aa 86213 mn 6161 86313 mx 6161 86413 sp -------------------------------- 86514 a cc 86614 mn 6363 86714 mx 6363 86814 sp -------------------------------- 86915 a ch 87015 mn 6368 87115 mx 6368 87215 sp -------------------------------- 87316 a aa_ 87416 mn 61610000000000000000000000000000 87516 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 87616 sp -------------------------------- 87717 a cc_ 87817 mn 63630000000000000000000000000000 87917 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 88017 sp -------------------------------- 88118 a ch_ 88218 mn 63680000000000000000000000000000 88318 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 88418 sp -------------------------------- 88519 a aa% 88619 mn 61610000000000000000000000000000 88719 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 88819 sp -------------------------------- 88920 a cc% 89020 mn 63630000000000000000000000000000 89120 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 89220 sp -------------------------------- 89321 a ch% 89421 mn 63680000000000000000000000000000 89521 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 89621 sp -------------------------------- 89722 a aaa 89822 mn 616161 89922 mx 616161 90022 sp -------------------------------- 90123 a ccc 90223 mn 636363 90323 mx 636363 90423 sp -------------------------------- 90524 a cch 90624 mn 636368 90724 mx 636368 90824 sp -------------------------------- 90925 a aaa_ 91025 mn 61616100000000000000000000000000 91125 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 91225 sp -------------------------------- 91326 a ccc_ 91426 mn 63636300000000000000000000000000 91526 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 91626 sp -------------------------------- 91727 a cch_ 91827 mn 63636800000000000000000000000000 91927 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 92027 sp -------------------------------- 92128 a aaa% 92228 mn 61616100000000000000000000000000 92328 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 92428 sp -------------------------------- 92529 a ccc% 92629 mn 63636300000000000000000000000000 92729 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 92829 sp -------------------------------- 92930 a cch% 93030 mn 63636800000000000000000000000000 93130 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 93230 sp -------------------------------- 93331 a aaaaaaaaaaaaaaaaaaaa 93431 mn 61616161 93531 mx 61616161 93631 sp -------------------------------- 93732 a caaaaaaaaaaaaaaaaaaa 93832 mn 63616161 93932 mx 63616161 94032 sp -------------------------------- 941ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 942SELECT * FROM v1; 943id name val 9441 a 9451 mn 9461 mx 9471 sp -------------------------------- 9482 a _ 9492 mn 09090909090909090909090909090909 9502 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 9512 sp -------------------------------- 9523 a % 9533 mn 09090909090909090909090909090909 9543 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 9553 sp -------------------------------- 9564 a \_ 9574 mn 5F 9584 mx 5F 9594 sp -------------------------------- 9605 a \% 9615 mn 25 9625 mx 25 9635 sp -------------------------------- 9646 a \ 9656 mn 5C 9666 mx 5C 9676 sp -------------------------------- 9687 a a 9697 mn 61 9707 mx 61 9717 sp -------------------------------- 9728 a c 9738 mn 63 9748 mx 63 9758 sp -------------------------------- 9769 a a_ 9779 mn 61090909090909090909090909090909 9789 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 9799 sp -------------------------------- 98010 a c_ 98110 mn 63090909090909090909090909090909 98210 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 98310 sp -------------------------------- 98411 a a% 98511 mn 61090909090909090909090909090909 98611 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 98711 sp -------------------------------- 98812 a c% 98912 mn 63090909090909090909090909090909 99012 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 99112 sp -------------------------------- 99213 a aa 99313 mn 6161 99413 mx 6161 99513 sp -------------------------------- 99614 a cc 99714 mn 6363 99814 mx 6363 99914 sp -------------------------------- 100015 a ch 100115 mn 6368 100215 mx 6368 100315 sp -------------------------------- 100416 a aa_ 100516 mn 61610909090909090909090909090909 100616 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 100716 sp -------------------------------- 100817 a cc_ 100917 mn 63630909090909090909090909090909 101017 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 101117 sp -------------------------------- 101218 a ch_ 101318 mn 63680909090909090909090909090909 101418 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 101518 sp -------------------------------- 101619 a aa% 101719 mn 61610909090909090909090909090909 101819 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 101919 sp -------------------------------- 102020 a cc% 102120 mn 63630909090909090909090909090909 102220 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 102320 sp -------------------------------- 102421 a ch% 102521 mn 63680909090909090909090909090909 102621 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 102721 sp -------------------------------- 102822 a aaa 102922 mn 616161 103022 mx 616161 103122 sp -------------------------------- 103223 a ccc 103323 mn 636363 103423 mx 636363 103523 sp -------------------------------- 103624 a cch 103724 mn 636368 103824 mx 636368 103924 sp -------------------------------- 104025 a aaa_ 104125 mn 61616109090909090909090909090909 104225 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 104325 sp -------------------------------- 104426 a ccc_ 104526 mn 63636309090909090909090909090909 104626 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 104726 sp -------------------------------- 104827 a cch_ 104927 mn 63636809090909090909090909090909 105027 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 105127 sp -------------------------------- 105228 a aaa% 105328 mn 61616109090909090909090909090909 105428 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 105528 sp -------------------------------- 105629 a ccc% 105729 mn 63636309090909090909090909090909 105829 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 105929 sp -------------------------------- 106030 a cch% 106130 mn 63636809090909090909090909090909 106230 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 106330 sp -------------------------------- 106431 a aaaaaaaaaaaaaaaaaaaa 106531 mn 61616161 106631 mx 61616161 106731 sp -------------------------------- 106832 a caaaaaaaaaaaaaaaaaaa 106932 mn 63616161 107032 mx 63616161 107132 sp -------------------------------- 1072ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci; 1073SELECT * FROM v1; 1074id name val 10751 a 10761 mn 10771 mx 10781 sp -------------------------------- 10792 a _ 10802 mn 09090909090909090909090909090909 10812 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 10822 sp -------------------------------- 10833 a % 10843 mn 09090909090909090909090909090909 10853 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 10863 sp -------------------------------- 10874 a \_ 10884 mn 5F 10894 mx 5F 10904 sp -------------------------------- 10915 a \% 10925 mn 25 10935 mx 25 10945 sp -------------------------------- 10956 a \ 10966 mn 5C 10976 mx 5C 10986 sp -------------------------------- 10997 a a 11007 mn 61 11017 mx 61 11027 sp -------------------------------- 11038 a c 11048 mn 63 11058 mx 63 11068 sp -------------------------------- 11079 a a_ 11089 mn 61090909090909090909090909090909 11099 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 11109 sp -------------------------------- 111110 a c_ 111210 mn 09090909090909090909090909090909 111310 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 111410 sp -------------------------------- 111511 a a% 111611 mn 61090909090909090909090909090909 111711 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 111811 sp -------------------------------- 111912 a c% 112012 mn 09090909090909090909090909090909 112112 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 112212 sp -------------------------------- 112313 a aa 112413 mn 6161 112513 mx 6161 112613 sp -------------------------------- 112714 a cc 112814 mn 6363 112914 mx 6363 113014 sp -------------------------------- 113115 a ch 113215 mn 6368 113315 mx 6368 113415 sp -------------------------------- 113516 a aa_ 113616 mn 61610909090909090909090909090909 113716 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 113816 sp -------------------------------- 113917 a cc_ 114017 mn 63090909090909090909090909090909 114117 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 114217 sp -------------------------------- 114318 a ch_ 114418 mn 63680909090909090909090909090909 114518 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 114618 sp -------------------------------- 114719 a aa% 114819 mn 61610909090909090909090909090909 114919 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 115019 sp -------------------------------- 115120 a cc% 115220 mn 63090909090909090909090909090909 115320 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 115420 sp -------------------------------- 115521 a ch% 115621 mn 63680909090909090909090909090909 115721 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 115821 sp -------------------------------- 115922 a aaa 116022 mn 616161 116122 mx 616161 116222 sp -------------------------------- 116323 a ccc 116423 mn 636363 116523 mx 636363 116623 sp -------------------------------- 116724 a cch 116824 mn 636368 116924 mx 636368 117024 sp -------------------------------- 117125 a aaa_ 117225 mn 61616109090909090909090909090909 117325 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 117425 sp -------------------------------- 117526 a ccc_ 117626 mn 63630909090909090909090909090909 117726 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 117826 sp -------------------------------- 117927 a cch_ 118027 mn 63636809090909090909090909090909 118127 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 118227 sp -------------------------------- 118328 a aaa% 118428 mn 61616109090909090909090909090909 118528 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 118628 sp -------------------------------- 118729 a ccc% 118829 mn 63630909090909090909090909090909 118929 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 119029 sp -------------------------------- 119130 a cch% 119230 mn 63636809090909090909090909090909 119330 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 119430 sp -------------------------------- 119531 a aaaaaaaaaaaaaaaaaaaa 119631 mn 61616161 119731 mx 61616161 119831 sp -------------------------------- 119932 a caaaaaaaaaaaaaaaaaaa 120032 mn 63616161 120132 mx 63616161 120232 sp -------------------------------- 1203ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci; 1204SELECT * FROM v1; 1205id name val 12061 a 12071 mn 12081 mx 12091 sp -------------------------------- 12102 a _ 12112 mn 09090909090909090909090909090909 12122 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 12132 sp -------------------------------- 12143 a % 12153 mn 09090909090909090909090909090909 12163 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 12173 sp -------------------------------- 12184 a \_ 12194 mn 5F 12204 mx 5F 12214 sp -------------------------------- 12225 a \% 12235 mn 25 12245 mx 25 12255 sp -------------------------------- 12266 a \ 12276 mn 5C 12286 mx 5C 12296 sp -------------------------------- 12307 a a 12317 mn 61 12327 mx 61 12337 sp -------------------------------- 12348 a c 12358 mn 63 12368 mx 63 12378 sp -------------------------------- 12389 a a_ 12399 mn 09090909090909090909090909090909 12409 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 12419 sp -------------------------------- 124210 a c_ 124310 mn 63090909090909090909090909090909 124410 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 124510 sp -------------------------------- 124611 a a% 124711 mn 09090909090909090909090909090909 124811 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 124911 sp -------------------------------- 125012 a c% 125112 mn 63090909090909090909090909090909 125212 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 125312 sp -------------------------------- 125413 a aa 125513 mn 6161 125613 mx 6161 125713 sp -------------------------------- 125814 a cc 125914 mn 6363 126014 mx 6363 126114 sp -------------------------------- 126215 a ch 126315 mn 6368 126415 mx 6368 126515 sp -------------------------------- 126616 a aa_ 126716 mn 61610909090909090909090909090909 126816 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 126916 sp -------------------------------- 127017 a cc_ 127117 mn 63630909090909090909090909090909 127217 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 127317 sp -------------------------------- 127418 a ch_ 127518 mn 63680909090909090909090909090909 127618 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 127718 sp -------------------------------- 127819 a aa% 127919 mn 61610909090909090909090909090909 128019 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 128119 sp -------------------------------- 128220 a cc% 128320 mn 63630909090909090909090909090909 128420 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 128520 sp -------------------------------- 128621 a ch% 128721 mn 63680909090909090909090909090909 128821 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 128921 sp -------------------------------- 129022 a aaa 129122 mn 616161 129222 mx 616161 129322 sp -------------------------------- 129423 a ccc 129523 mn 636363 129623 mx 636363 129723 sp -------------------------------- 129824 a cch 129924 mn 636368 130024 mx 636368 130124 sp -------------------------------- 130225 a aaa_ 130325 mn 61610909090909090909090909090909 130425 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 130525 sp -------------------------------- 130626 a ccc_ 130726 mn 63636309090909090909090909090909 130826 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 130926 sp -------------------------------- 131027 a cch_ 131127 mn 63636809090909090909090909090909 131227 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 131327 sp -------------------------------- 131428 a aaa% 131528 mn 61610909090909090909090909090909 131628 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 131728 sp -------------------------------- 131829 a ccc% 131929 mn 63636309090909090909090909090909 132029 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 132129 sp -------------------------------- 132230 a cch% 132330 mn 63636809090909090909090909090909 132430 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 132530 sp -------------------------------- 132631 a aaaaaaaaaaaaaaaaaaaa 132731 mn 61616161 132831 mx 61616161 132931 sp -------------------------------- 133032 a caaaaaaaaaaaaaaaaaaa 133132 mn 63616109090909090909090909090909 133232 mx 636161EFBFBFEFBFBFEFBFBFEFBFBF20 133332 sp -------------------------------- 1334ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; 1335SELECT * FROM v1; 1336id name val 13371 a 13381 mn 13391 mx 13401 sp -------------------------------- 13412 a _ 13422 mn 09090909090909090909090909090909 13432 mx F48FBFBFF48FBFBFF48FBFBFF48FBFBF 13442 sp -------------------------------- 13453 a % 13463 mn 09090909090909090909090909090909 13473 mx F48FBFBFF48FBFBFF48FBFBFF48FBFBF 13483 sp -------------------------------- 13494 a \_ 13504 mn 5F 13514 mx 5F 13524 sp -------------------------------- 13535 a \% 13545 mn 25 13555 mx 25 13565 sp -------------------------------- 13576 a \ 13586 mn 5C 13596 mx 5C 13606 sp -------------------------------- 13617 a a 13627 mn 61 13637 mx 61 13647 sp -------------------------------- 13658 a c 13668 mn 63 13678 mx 63 13688 sp -------------------------------- 13699 a a_ 13709 mn 61090909090909090909090909090909 13719 mx 61F48FBFBFF48FBFBFF48FBFBF202020 13729 sp -------------------------------- 137310 a c_ 137410 mn 63090909090909090909090909090909 137510 mx 63F48FBFBFF48FBFBFF48FBFBF202020 137610 sp -------------------------------- 137711 a a% 137811 mn 61090909090909090909090909090909 137911 mx 61F48FBFBFF48FBFBFF48FBFBF202020 138011 sp -------------------------------- 138112 a c% 138212 mn 63090909090909090909090909090909 138312 mx 63F48FBFBFF48FBFBFF48FBFBF202020 138412 sp -------------------------------- 138513 a aa 138613 mn 6161 138713 mx 6161 138813 sp -------------------------------- 138914 a cc 139014 mn 6363 139114 mx 6363 139214 sp -------------------------------- 139315 a ch 139415 mn 6368 139515 mx 6368 139615 sp -------------------------------- 139716 a aa_ 139816 mn 61610909090909090909090909090909 139916 mx 6161F48FBFBFF48FBFBFF48FBFBF2020 140016 sp -------------------------------- 140117 a cc_ 140217 mn 63630909090909090909090909090909 140317 mx 6363F48FBFBFF48FBFBFF48FBFBF2020 140417 sp -------------------------------- 140518 a ch_ 140618 mn 63680909090909090909090909090909 140718 mx 6368F48FBFBFF48FBFBFF48FBFBF2020 140818 sp -------------------------------- 140919 a aa% 141019 mn 61610909090909090909090909090909 141119 mx 6161F48FBFBFF48FBFBFF48FBFBF2020 141219 sp -------------------------------- 141320 a cc% 141420 mn 63630909090909090909090909090909 141520 mx 6363F48FBFBFF48FBFBFF48FBFBF2020 141620 sp -------------------------------- 141721 a ch% 141821 mn 63680909090909090909090909090909 141921 mx 6368F48FBFBFF48FBFBFF48FBFBF2020 142021 sp -------------------------------- 142122 a aaa 142222 mn 616161 142322 mx 616161 142422 sp -------------------------------- 142523 a ccc 142623 mn 636363 142723 mx 636363 142823 sp -------------------------------- 142924 a cch 143024 mn 636368 143124 mx 636368 143224 sp -------------------------------- 143325 a aaa_ 143425 mn 61616109090909090909090909090909 143525 mx 616161F48FBFBFF48FBFBFF48FBFBF20 143625 sp -------------------------------- 143726 a ccc_ 143826 mn 63636309090909090909090909090909 143926 mx 636363F48FBFBFF48FBFBFF48FBFBF20 144026 sp -------------------------------- 144127 a cch_ 144227 mn 63636809090909090909090909090909 144327 mx 636368F48FBFBFF48FBFBFF48FBFBF20 144427 sp -------------------------------- 144528 a aaa% 144628 mn 61616109090909090909090909090909 144728 mx 616161F48FBFBFF48FBFBFF48FBFBF20 144828 sp -------------------------------- 144929 a ccc% 145029 mn 63636309090909090909090909090909 145129 mx 636363F48FBFBFF48FBFBFF48FBFBF20 145229 sp -------------------------------- 145330 a cch% 145430 mn 63636809090909090909090909090909 145530 mx 636368F48FBFBFF48FBFBFF48FBFBF20 145630 sp -------------------------------- 145731 a aaaaaaaaaaaaaaaaaaaa 145831 mn 61616161 145931 mx 61616161 146031 sp -------------------------------- 146132 a caaaaaaaaaaaaaaaaaaa 146232 mn 63616161 146332 mx 63616161 146432 sp -------------------------------- 1465ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2; 1466SELECT * FROM v1; 1467id name val 14681 a 14691 mn 14701 mx 14711 sp -------------------------------- 14722 a _ 14732 mn 0000 14742 mx FFFF 14752 sp -------------------------------- 14763 a % 14773 mn 00000000000000000000000000000000 14783 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 14793 sp -------------------------------- 14804 a \_ 14814 mn 005F 14824 mx 005F 14834 sp -------------------------------- 14845 a \% 14855 mn 0025 14865 mx 0025 14875 sp -------------------------------- 14886 a \ 14896 mn 005C 14906 mx 005C 14916 sp -------------------------------- 14927 a a 14937 mn 0061 14947 mx 0061 14957 sp -------------------------------- 14968 a c 14978 mn 0063 14988 mx 0063 14998 sp -------------------------------- 15009 a a_ 15019 mn 00610000 15029 mx 0061FFFF 15039 sp -------------------------------- 150410 a c_ 150510 mn 00630000 150610 mx 0063FFFF 150710 sp -------------------------------- 150811 a a% 150911 mn 00610000000000000000000000000000 151011 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 151111 sp -------------------------------- 151212 a c% 151312 mn 00630000000000000000000000000000 151412 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 151512 sp -------------------------------- 151613 a aa 151713 mn 00610061 151813 mx 00610061 151913 sp -------------------------------- 152014 a cc 152114 mn 00630063 152214 mx 00630063 152314 sp -------------------------------- 152415 a ch 152515 mn 00630068 152615 mx 00630068 152715 sp -------------------------------- 152816 a aa_ 152916 mn 006100610000 153016 mx 00610061FFFF 153116 sp -------------------------------- 153217 a cc_ 153317 mn 006300630000 153417 mx 00630063FFFF 153517 sp -------------------------------- 153618 a ch_ 153718 mn 006300680000 153818 mx 00630068FFFF 153918 sp -------------------------------- 154019 a aa% 154119 mn 00610061000000000000000000000000 154219 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 154319 sp -------------------------------- 154420 a cc% 154520 mn 00630063000000000000000000000000 154620 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 154720 sp -------------------------------- 154821 a ch% 154921 mn 00630068000000000000000000000000 155021 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 155121 sp -------------------------------- 155222 a aaa 155322 mn 006100610061 155422 mx 006100610061 155522 sp -------------------------------- 155623 a ccc 155723 mn 006300630063 155823 mx 006300630063 155923 sp -------------------------------- 156024 a cch 156124 mn 006300630068 156224 mx 006300630068 156324 sp -------------------------------- 156425 a aaa_ 156525 mn 0061006100610000 156625 mx 006100610061FFFF 156725 sp -------------------------------- 156826 a ccc_ 156926 mn 0063006300630000 157026 mx 006300630063FFFF 157126 sp -------------------------------- 157227 a cch_ 157327 mn 0063006300680000 157427 mx 006300630068FFFF 157527 sp -------------------------------- 157628 a aaa% 157728 mn 00610061006100000000000000000000 157828 mx 006100610061FFFFFFFFFFFFFFFFFFFF 157928 sp -------------------------------- 158029 a ccc% 158129 mn 00630063006300000000000000000000 158229 mx 006300630063FFFFFFFFFFFFFFFFFFFF 158329 sp -------------------------------- 158430 a cch% 158530 mn 00630063006800000000000000000000 158630 mx 006300630068FFFFFFFFFFFFFFFFFFFF 158730 sp -------------------------------- 158831 a aaaaaaaaaaaaaaaaaaaa 158931 mn 00610061006100610061006100610061 159031 mx 00610061006100610061006100610061 159131 sp -------------------------------- 159232 a caaaaaaaaaaaaaaaaaaa 159332 mn 00630061006100610061006100610061 159432 mx 00630061006100610061006100610061 159532 sp -------------------------------- 1596ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_unicode_ci; 1597SELECT * FROM v1; 1598id name val 15991 a 16001 mn 16011 mx 16021 sp -------------------------------- 16032 a _ 16042 mn 0009 16052 mx FFFF 16062 sp -------------------------------- 16073 a % 16083 mn 00090009000900090009000900090009 16093 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 16103 sp -------------------------------- 16114 a \_ 16124 mn 005F 16134 mx 005F 16144 sp -------------------------------- 16155 a \% 16165 mn 0025 16175 mx 0025 16185 sp -------------------------------- 16196 a \ 16206 mn 005C 16216 mx 005C 16226 sp -------------------------------- 16237 a a 16247 mn 0061 16257 mx 0061 16267 sp -------------------------------- 16278 a c 16288 mn 0063 16298 mx 0063 16308 sp -------------------------------- 16319 a a_ 16329 mn 00610009 16339 mx 0061FFFF 16349 sp -------------------------------- 163510 a c_ 163610 mn 00630009 163710 mx 0063FFFF 163810 sp -------------------------------- 163911 a a% 164011 mn 00610009000900090009000900090009 164111 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 164211 sp -------------------------------- 164312 a c% 164412 mn 00630009000900090009000900090009 164512 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 164612 sp -------------------------------- 164713 a aa 164813 mn 00610061 164913 mx 00610061 165013 sp -------------------------------- 165114 a cc 165214 mn 00630063 165314 mx 00630063 165414 sp -------------------------------- 165515 a ch 165615 mn 00630068 165715 mx 00630068 165815 sp -------------------------------- 165916 a aa_ 166016 mn 006100610009 166116 mx 00610061FFFF 166216 sp -------------------------------- 166317 a cc_ 166417 mn 006300630009 166517 mx 00630063FFFF 166617 sp -------------------------------- 166718 a ch_ 166818 mn 006300680009 166918 mx 00630068FFFF 167018 sp -------------------------------- 167119 a aa% 167219 mn 00610061000900090009000900090009 167319 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 167419 sp -------------------------------- 167520 a cc% 167620 mn 00630063000900090009000900090009 167720 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 167820 sp -------------------------------- 167921 a ch% 168021 mn 00630068000900090009000900090009 168121 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 168221 sp -------------------------------- 168322 a aaa 168422 mn 006100610061 168522 mx 006100610061 168622 sp -------------------------------- 168723 a ccc 168823 mn 006300630063 168923 mx 006300630063 169023 sp -------------------------------- 169124 a cch 169224 mn 006300630068 169324 mx 006300630068 169424 sp -------------------------------- 169525 a aaa_ 169625 mn 0061006100610009 169725 mx 006100610061FFFF 169825 sp -------------------------------- 169926 a ccc_ 170026 mn 0063006300630009 170126 mx 006300630063FFFF 170226 sp -------------------------------- 170327 a cch_ 170427 mn 0063006300680009 170527 mx 006300630068FFFF 170627 sp -------------------------------- 170728 a aaa% 170828 mn 00610061006100090009000900090009 170928 mx 006100610061FFFFFFFFFFFFFFFFFFFF 171028 sp -------------------------------- 171129 a ccc% 171229 mn 00630063006300090009000900090009 171329 mx 006300630063FFFFFFFFFFFFFFFFFFFF 171429 sp -------------------------------- 171530 a cch% 171630 mn 00630063006800090009000900090009 171730 mx 006300630068FFFFFFFFFFFFFFFFFFFF 171830 sp -------------------------------- 171931 a aaaaaaaaaaaaaaaaaaaa 172031 mn 00610061006100610061006100610061 172131 mx 00610061006100610061006100610061 172231 sp -------------------------------- 172332 a caaaaaaaaaaaaaaaaaaa 172432 mn 00630061006100610061006100610061 172532 mx 00630061006100610061006100610061 172632 sp -------------------------------- 1727ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_czech_ci; 1728SELECT * FROM v1; 1729id name val 17301 a 17311 mn 17321 mx 17331 sp -------------------------------- 17342 a _ 17352 mn 0009 17362 mx FFFF 17372 sp -------------------------------- 17383 a % 17393 mn 00090009000900090009000900090009 17403 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 17413 sp -------------------------------- 17424 a \_ 17434 mn 005F 17444 mx 005F 17454 sp -------------------------------- 17465 a \% 17475 mn 0025 17485 mx 0025 17495 sp -------------------------------- 17506 a \ 17516 mn 005C 17526 mx 005C 17536 sp -------------------------------- 17547 a a 17557 mn 0061 17567 mx 0061 17577 sp -------------------------------- 17588 a c 17598 mn 0063 17608 mx 0063 17618 sp -------------------------------- 17629 a a_ 17639 mn 00610009 17649 mx 0061FFFF 17659 sp -------------------------------- 176610 a c_ 176710 mn 00090009000900090009000900090009 176810 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 176910 sp -------------------------------- 177011 a a% 177111 mn 00610009000900090009000900090009 177211 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 177311 sp -------------------------------- 177412 a c% 177512 mn 00090009000900090009000900090009 177612 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 177712 sp -------------------------------- 177813 a aa 177913 mn 00610061 178013 mx 00610061 178113 sp -------------------------------- 178214 a cc 178314 mn 00630063 178414 mx 00630063 178514 sp -------------------------------- 178615 a ch 178715 mn 00630068 178815 mx 00630068 178915 sp -------------------------------- 179016 a aa_ 179116 mn 006100610009 179216 mx 00610061FFFF 179316 sp -------------------------------- 179417 a cc_ 179517 mn 00630009000900090009000900090009 179617 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 179717 sp -------------------------------- 179818 a ch_ 179918 mn 006300680009 180018 mx 00630068FFFF 180118 sp -------------------------------- 180219 a aa% 180319 mn 00610061000900090009000900090009 180419 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 180519 sp -------------------------------- 180620 a cc% 180720 mn 00630009000900090009000900090009 180820 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 180920 sp -------------------------------- 181021 a ch% 181121 mn 00630068000900090009000900090009 181221 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 181321 sp -------------------------------- 181422 a aaa 181522 mn 006100610061 181622 mx 006100610061 181722 sp -------------------------------- 181823 a ccc 181923 mn 006300630063 182023 mx 006300630063 182123 sp -------------------------------- 182224 a cch 182324 mn 006300630068 182424 mx 006300630068 182524 sp -------------------------------- 182625 a aaa_ 182725 mn 0061006100610009 182825 mx 006100610061FFFF 182925 sp -------------------------------- 183026 a ccc_ 183126 mn 00630063000900090009000900090009 183226 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 183326 sp -------------------------------- 183427 a cch_ 183527 mn 0063006300680009 183627 mx 006300630068FFFF 183727 sp -------------------------------- 183828 a aaa% 183928 mn 00610061006100090009000900090009 184028 mx 006100610061FFFFFFFFFFFFFFFFFFFF 184128 sp -------------------------------- 184229 a ccc% 184329 mn 00630063000900090009000900090009 184429 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 184529 sp -------------------------------- 184630 a cch% 184730 mn 00630063006800090009000900090009 184830 mx 006300630068FFFFFFFFFFFFFFFFFFFF 184930 sp -------------------------------- 185031 a aaaaaaaaaaaaaaaaaaaa 185131 mn 00610061006100610061006100610061 185231 mx 00610061006100610061006100610061 185331 sp -------------------------------- 185432 a caaaaaaaaaaaaaaaaaaa 185532 mn 00630061006100610061006100610061 185632 mx 00630061006100610061006100610061 185732 sp -------------------------------- 1858ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_danish_ci; 1859SELECT * FROM v1; 1860id name val 18611 a 18621 mn 18631 mx 18641 sp -------------------------------- 18652 a _ 18662 mn 0009 18672 mx FFFF 18682 sp -------------------------------- 18693 a % 18703 mn 00090009000900090009000900090009 18713 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 18723 sp -------------------------------- 18734 a \_ 18744 mn 005F 18754 mx 005F 18764 sp -------------------------------- 18775 a \% 18785 mn 0025 18795 mx 0025 18805 sp -------------------------------- 18816 a \ 18826 mn 005C 18836 mx 005C 18846 sp -------------------------------- 18857 a a 18867 mn 0061 18877 mx 0061 18887 sp -------------------------------- 18898 a c 18908 mn 0063 18918 mx 0063 18928 sp -------------------------------- 18939 a a_ 18949 mn 00090009000900090009000900090009 18959 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 18969 sp -------------------------------- 189710 a c_ 189810 mn 00630009 189910 mx 0063FFFF 190010 sp -------------------------------- 190111 a a% 190211 mn 00090009000900090009000900090009 190311 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 190411 sp -------------------------------- 190512 a c% 190612 mn 00630009000900090009000900090009 190712 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 190812 sp -------------------------------- 190913 a aa 191013 mn 00610061 191113 mx 00610061 191213 sp -------------------------------- 191314 a cc 191414 mn 00630063 191514 mx 00630063 191614 sp -------------------------------- 191715 a ch 191815 mn 00630068 191915 mx 00630068 192015 sp -------------------------------- 192116 a aa_ 192216 mn 006100610009 192316 mx 00610061FFFF 192416 sp -------------------------------- 192517 a cc_ 192617 mn 006300630009 192717 mx 00630063FFFF 192817 sp -------------------------------- 192918 a ch_ 193018 mn 006300680009 193118 mx 00630068FFFF 193218 sp -------------------------------- 193319 a aa% 193419 mn 00610061000900090009000900090009 193519 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 193619 sp -------------------------------- 193720 a cc% 193820 mn 00630063000900090009000900090009 193920 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 194020 sp -------------------------------- 194121 a ch% 194221 mn 00630068000900090009000900090009 194321 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 194421 sp -------------------------------- 194522 a aaa 194622 mn 006100610061 194722 mx 006100610061 194822 sp -------------------------------- 194923 a ccc 195023 mn 006300630063 195123 mx 006300630063 195223 sp -------------------------------- 195324 a cch 195424 mn 006300630068 195524 mx 006300630068 195624 sp -------------------------------- 195725 a aaa_ 195825 mn 00610061000900090009000900090009 195925 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 196025 sp -------------------------------- 196126 a ccc_ 196226 mn 0063006300630009 196326 mx 006300630063FFFF 196426 sp -------------------------------- 196527 a cch_ 196627 mn 0063006300680009 196727 mx 006300630068FFFF 196827 sp -------------------------------- 196928 a aaa% 197028 mn 00610061000900090009000900090009 197128 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 197228 sp -------------------------------- 197329 a ccc% 197429 mn 00630063006300090009000900090009 197529 mx 006300630063FFFFFFFFFFFFFFFFFFFF 197629 sp -------------------------------- 197730 a cch% 197830 mn 00630063006800090009000900090009 197930 mx 006300630068FFFFFFFFFFFFFFFFFFFF 198030 sp -------------------------------- 198131 a aaaaaaaaaaaaaaaaaaaa 198231 mn 00610061006100610061006100610061 198331 mx 00610061006100610061006100610061 198431 sp -------------------------------- 198532 a caaaaaaaaaaaaaaaaaaa 198632 mn 00630061006100610061006100610009 198732 mx 0063006100610061006100610061FFFF 198832 sp -------------------------------- 1989ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16; 1990SELECT * FROM v1; 1991id name val 19921 a 19931 mn 19941 mx 19951 sp -------------------------------- 19962 a _ 19972 mn 0000 19982 mx FFFF 19992 sp -------------------------------- 20003 a % 20013 mn 00000000000000000000000000000000 20023 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 20033 sp -------------------------------- 20044 a \_ 20054 mn 005F 20064 mx 005F 20074 sp -------------------------------- 20085 a \% 20095 mn 0025 20105 mx 0025 20115 sp -------------------------------- 20126 a \ 20136 mn 005C 20146 mx 005C 20156 sp -------------------------------- 20167 a a 20177 mn 0061 20187 mx 0061 20197 sp -------------------------------- 20208 a c 20218 mn 0063 20228 mx 0063 20238 sp -------------------------------- 20249 a a_ 20259 mn 00610000 20269 mx 0061FFFF 20279 sp -------------------------------- 202810 a c_ 202910 mn 00630000 203010 mx 0063FFFF 203110 sp -------------------------------- 203211 a a% 203311 mn 00610000000000000000000000000000 203411 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 203511 sp -------------------------------- 203612 a c% 203712 mn 00630000000000000000000000000000 203812 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 203912 sp -------------------------------- 204013 a aa 204113 mn 00610061 204213 mx 00610061 204313 sp -------------------------------- 204414 a cc 204514 mn 00630063 204614 mx 00630063 204714 sp -------------------------------- 204815 a ch 204915 mn 00630068 205015 mx 00630068 205115 sp -------------------------------- 205216 a aa_ 205316 mn 006100610000 205416 mx 00610061FFFF 205516 sp -------------------------------- 205617 a cc_ 205717 mn 006300630000 205817 mx 00630063FFFF 205917 sp -------------------------------- 206018 a ch_ 206118 mn 006300680000 206218 mx 00630068FFFF 206318 sp -------------------------------- 206419 a aa% 206519 mn 00610061000000000000000000000000 206619 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 206719 sp -------------------------------- 206820 a cc% 206920 mn 00630063000000000000000000000000 207020 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 207120 sp -------------------------------- 207221 a ch% 207321 mn 00630068000000000000000000000000 207421 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 207521 sp -------------------------------- 207622 a aaa 207722 mn 006100610061 207822 mx 006100610061 207922 sp -------------------------------- 208023 a ccc 208123 mn 006300630063 208223 mx 006300630063 208323 sp -------------------------------- 208424 a cch 208524 mn 006300630068 208624 mx 006300630068 208724 sp -------------------------------- 208825 a aaa_ 208925 mn 0061006100610000 209025 mx 006100610061FFFF 209125 sp -------------------------------- 209226 a ccc_ 209326 mn 0063006300630000 209426 mx 006300630063FFFF 209526 sp -------------------------------- 209627 a cch_ 209727 mn 0063006300680000 209827 mx 006300630068FFFF 209927 sp -------------------------------- 210028 a aaa% 210128 mn 00610061006100000000000000000000 210228 mx 006100610061FFFFFFFFFFFFFFFFFFFF 210328 sp -------------------------------- 210429 a ccc% 210529 mn 00630063006300000000000000000000 210629 mx 006300630063FFFFFFFFFFFFFFFFFFFF 210729 sp -------------------------------- 210830 a cch% 210930 mn 00630063006800000000000000000000 211030 mx 006300630068FFFFFFFFFFFFFFFFFFFF 211130 sp -------------------------------- 211231 a aaaaaaaaaaaaaaaaaaaa 211331 mn 0061006100610061 211431 mx 0061006100610061 211531 sp -------------------------------- 211632 a caaaaaaaaaaaaaaaaaaa 211732 mn 0063006100610061 211832 mx 0063006100610061 211932 sp -------------------------------- 2120ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_unicode_ci; 2121SELECT * FROM v1; 2122id name val 21231 a 21241 mn 21251 mx 21261 sp -------------------------------- 21272 a _ 21282 mn 0009 21292 mx FFFF 21302 sp -------------------------------- 21313 a % 21323 mn 00090009000900090009000900090009 21333 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 21343 sp -------------------------------- 21354 a \_ 21364 mn 005F 21374 mx 005F 21384 sp -------------------------------- 21395 a \% 21405 mn 0025 21415 mx 0025 21425 sp -------------------------------- 21436 a \ 21446 mn 005C 21456 mx 005C 21466 sp -------------------------------- 21477 a a 21487 mn 0061 21497 mx 0061 21507 sp -------------------------------- 21518 a c 21528 mn 0063 21538 mx 0063 21548 sp -------------------------------- 21559 a a_ 21569 mn 00610009 21579 mx 0061FFFF 21589 sp -------------------------------- 215910 a c_ 216010 mn 00630009 216110 mx 0063FFFF 216210 sp -------------------------------- 216311 a a% 216411 mn 00610009000900090009000900090009 216511 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 216611 sp -------------------------------- 216712 a c% 216812 mn 00630009000900090009000900090009 216912 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 217012 sp -------------------------------- 217113 a aa 217213 mn 00610061 217313 mx 00610061 217413 sp -------------------------------- 217514 a cc 217614 mn 00630063 217714 mx 00630063 217814 sp -------------------------------- 217915 a ch 218015 mn 00630068 218115 mx 00630068 218215 sp -------------------------------- 218316 a aa_ 218416 mn 006100610009 218516 mx 00610061FFFF 218616 sp -------------------------------- 218717 a cc_ 218817 mn 006300630009 218917 mx 00630063FFFF 219017 sp -------------------------------- 219118 a ch_ 219218 mn 006300680009 219318 mx 00630068FFFF 219418 sp -------------------------------- 219519 a aa% 219619 mn 00610061000900090009000900090009 219719 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 219819 sp -------------------------------- 219920 a cc% 220020 mn 00630063000900090009000900090009 220120 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 220220 sp -------------------------------- 220321 a ch% 220421 mn 00630068000900090009000900090009 220521 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 220621 sp -------------------------------- 220722 a aaa 220822 mn 006100610061 220922 mx 006100610061 221022 sp -------------------------------- 221123 a ccc 221223 mn 006300630063 221323 mx 006300630063 221423 sp -------------------------------- 221524 a cch 221624 mn 006300630068 221724 mx 006300630068 221824 sp -------------------------------- 221925 a aaa_ 222025 mn 0061006100610009 222125 mx 006100610061FFFF 222225 sp -------------------------------- 222326 a ccc_ 222426 mn 0063006300630009 222526 mx 006300630063FFFF 222626 sp -------------------------------- 222727 a cch_ 222827 mn 0063006300680009 222927 mx 006300630068FFFF 223027 sp -------------------------------- 223128 a aaa% 223228 mn 00610061006100090009000900090009 223328 mx 006100610061FFFFFFFFFFFFFFFFFFFF 223428 sp -------------------------------- 223529 a ccc% 223629 mn 00630063006300090009000900090009 223729 mx 006300630063FFFFFFFFFFFFFFFFFFFF 223829 sp -------------------------------- 223930 a cch% 224030 mn 00630063006800090009000900090009 224130 mx 006300630068FFFFFFFFFFFFFFFFFFFF 224230 sp -------------------------------- 224331 a aaaaaaaaaaaaaaaaaaaa 224431 mn 0061006100610061 224531 mx 0061006100610061 224631 sp -------------------------------- 224732 a caaaaaaaaaaaaaaaaaaa 224832 mn 0063006100610061 224932 mx 0063006100610061 225032 sp -------------------------------- 2251ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_czech_ci; 2252SELECT * FROM v1; 2253id name val 22541 a 22551 mn 22561 mx 22571 sp -------------------------------- 22582 a _ 22592 mn 0009 22602 mx FFFF 22612 sp -------------------------------- 22623 a % 22633 mn 00090009000900090009000900090009 22643 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 22653 sp -------------------------------- 22664 a \_ 22674 mn 005F 22684 mx 005F 22694 sp -------------------------------- 22705 a \% 22715 mn 0025 22725 mx 0025 22735 sp -------------------------------- 22746 a \ 22756 mn 005C 22766 mx 005C 22776 sp -------------------------------- 22787 a a 22797 mn 0061 22807 mx 0061 22817 sp -------------------------------- 22828 a c 22838 mn 0063 22848 mx 0063 22858 sp -------------------------------- 22869 a a_ 22879 mn 00610009 22889 mx 0061FFFF 22899 sp -------------------------------- 229010 a c_ 229110 mn 00090009000900090009000900090009 229210 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 229310 sp -------------------------------- 229411 a a% 229511 mn 00610009000900090009000900090009 229611 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 229711 sp -------------------------------- 229812 a c% 229912 mn 00090009000900090009000900090009 230012 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 230112 sp -------------------------------- 230213 a aa 230313 mn 00610061 230413 mx 00610061 230513 sp -------------------------------- 230614 a cc 230714 mn 00630063 230814 mx 00630063 230914 sp -------------------------------- 231015 a ch 231115 mn 00630068 231215 mx 00630068 231315 sp -------------------------------- 231416 a aa_ 231516 mn 006100610009 231616 mx 00610061FFFF 231716 sp -------------------------------- 231817 a cc_ 231917 mn 00630009000900090009000900090009 232017 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 232117 sp -------------------------------- 232218 a ch_ 232318 mn 006300680009 232418 mx 00630068FFFF 232518 sp -------------------------------- 232619 a aa% 232719 mn 00610061000900090009000900090009 232819 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 232919 sp -------------------------------- 233020 a cc% 233120 mn 00630009000900090009000900090009 233220 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 233320 sp -------------------------------- 233421 a ch% 233521 mn 00630068000900090009000900090009 233621 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 233721 sp -------------------------------- 233822 a aaa 233922 mn 006100610061 234022 mx 006100610061 234122 sp -------------------------------- 234223 a ccc 234323 mn 006300630063 234423 mx 006300630063 234523 sp -------------------------------- 234624 a cch 234724 mn 006300630068 234824 mx 006300630068 234924 sp -------------------------------- 235025 a aaa_ 235125 mn 0061006100610009 235225 mx 006100610061FFFF 235325 sp -------------------------------- 235426 a ccc_ 235526 mn 00630063000900090009000900090009 235626 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 235726 sp -------------------------------- 235827 a cch_ 235927 mn 0063006300680009 236027 mx 006300630068FFFF 236127 sp -------------------------------- 236228 a aaa% 236328 mn 00610061006100090009000900090009 236428 mx 006100610061FFFFFFFFFFFFFFFFFFFF 236528 sp -------------------------------- 236629 a ccc% 236729 mn 00630063000900090009000900090009 236829 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 236929 sp -------------------------------- 237030 a cch% 237130 mn 00630063006800090009000900090009 237230 mx 006300630068FFFFFFFFFFFFFFFFFFFF 237330 sp -------------------------------- 237431 a aaaaaaaaaaaaaaaaaaaa 237531 mn 0061006100610061 237631 mx 0061006100610061 237731 sp -------------------------------- 237832 a caaaaaaaaaaaaaaaaaaa 237932 mn 0063006100610061 238032 mx 0063006100610061 238132 sp -------------------------------- 2382ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_danish_ci; 2383SELECT * FROM v1; 2384id name val 23851 a 23861 mn 23871 mx 23881 sp -------------------------------- 23892 a _ 23902 mn 0009 23912 mx FFFF 23922 sp -------------------------------- 23933 a % 23943 mn 00090009000900090009000900090009 23953 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 23963 sp -------------------------------- 23974 a \_ 23984 mn 005F 23994 mx 005F 24004 sp -------------------------------- 24015 a \% 24025 mn 0025 24035 mx 0025 24045 sp -------------------------------- 24056 a \ 24066 mn 005C 24076 mx 005C 24086 sp -------------------------------- 24097 a a 24107 mn 0061 24117 mx 0061 24127 sp -------------------------------- 24138 a c 24148 mn 0063 24158 mx 0063 24168 sp -------------------------------- 24179 a a_ 24189 mn 00090009000900090009000900090009 24199 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 24209 sp -------------------------------- 242110 a c_ 242210 mn 00630009 242310 mx 0063FFFF 242410 sp -------------------------------- 242511 a a% 242611 mn 00090009000900090009000900090009 242711 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 242811 sp -------------------------------- 242912 a c% 243012 mn 00630009000900090009000900090009 243112 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 243212 sp -------------------------------- 243313 a aa 243413 mn 00610061 243513 mx 00610061 243613 sp -------------------------------- 243714 a cc 243814 mn 00630063 243914 mx 00630063 244014 sp -------------------------------- 244115 a ch 244215 mn 00630068 244315 mx 00630068 244415 sp -------------------------------- 244516 a aa_ 244616 mn 006100610009 244716 mx 00610061FFFF 244816 sp -------------------------------- 244917 a cc_ 245017 mn 006300630009 245117 mx 00630063FFFF 245217 sp -------------------------------- 245318 a ch_ 245418 mn 006300680009 245518 mx 00630068FFFF 245618 sp -------------------------------- 245719 a aa% 245819 mn 00610061000900090009000900090009 245919 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 246019 sp -------------------------------- 246120 a cc% 246220 mn 00630063000900090009000900090009 246320 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 246420 sp -------------------------------- 246521 a ch% 246621 mn 00630068000900090009000900090009 246721 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 246821 sp -------------------------------- 246922 a aaa 247022 mn 006100610061 247122 mx 006100610061 247222 sp -------------------------------- 247323 a ccc 247423 mn 006300630063 247523 mx 006300630063 247623 sp -------------------------------- 247724 a cch 247824 mn 006300630068 247924 mx 006300630068 248024 sp -------------------------------- 248125 a aaa_ 248225 mn 00610061000900090009000900090009 248325 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 248425 sp -------------------------------- 248526 a ccc_ 248626 mn 0063006300630009 248726 mx 006300630063FFFF 248826 sp -------------------------------- 248927 a cch_ 249027 mn 0063006300680009 249127 mx 006300630068FFFF 249227 sp -------------------------------- 249328 a aaa% 249428 mn 00610061000900090009000900090009 249528 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 249628 sp -------------------------------- 249729 a ccc% 249829 mn 00630063006300090009000900090009 249929 mx 006300630063FFFFFFFFFFFFFFFFFFFF 250029 sp -------------------------------- 250130 a cch% 250230 mn 00630063006800090009000900090009 250330 mx 006300630068FFFFFFFFFFFFFFFFFFFF 250430 sp -------------------------------- 250531 a aaaaaaaaaaaaaaaaaaaa 250631 mn 0061006100610061 250731 mx 0061006100610061 250831 sp -------------------------------- 250932 a caaaaaaaaaaaaaaaaaaa 251032 mn 00630061006100090009000900090009 251132 mx 006300610061FFFFFFFFFFFFFFFFFFFF 251232 sp -------------------------------- 2513ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_unicode_520_ci; 2514SELECT * FROM v1; 2515id name val 25161 a 25171 mn 25181 mx 25191 sp -------------------------------- 25202 a _ 25212 mn 0009 25222 mx DBFFDFFF 25232 sp -------------------------------- 25243 a % 25253 mn 00090009000900090009000900090009 25263 mx DBFFDFFFDBFFDFFFDBFFDFFFDBFFDFFF 25273 sp -------------------------------- 25284 a \_ 25294 mn 005F 25304 mx 005F 25314 sp -------------------------------- 25325 a \% 25335 mn 0025 25345 mx 0025 25355 sp -------------------------------- 25366 a \ 25376 mn 005C 25386 mx 005C 25396 sp -------------------------------- 25407 a a 25417 mn 0061 25427 mx 0061 25437 sp -------------------------------- 25448 a c 25458 mn 0063 25468 mx 0063 25478 sp -------------------------------- 25489 a a_ 25499 mn 00610009 25509 mx 0061DBFFDFFF 25519 sp -------------------------------- 255210 a c_ 255310 mn 00630009 255410 mx 0063DBFFDFFF 255510 sp -------------------------------- 255611 a a% 255711 mn 00610009000900090009000900090009 255811 mx 0061DBFFDFFFDBFFDFFFDBFFDFFF0000 255911 sp -------------------------------- 256012 a c% 256112 mn 00630009000900090009000900090009 256212 mx 0063DBFFDFFFDBFFDFFFDBFFDFFF0000 256312 sp -------------------------------- 256413 a aa 256513 mn 00610061 256613 mx 00610061 256713 sp -------------------------------- 256814 a cc 256914 mn 00630063 257014 mx 00630063 257114 sp -------------------------------- 257215 a ch 257315 mn 00630068 257415 mx 00630068 257515 sp -------------------------------- 257616 a aa_ 257716 mn 006100610009 257816 mx 00610061DBFFDFFF 257916 sp -------------------------------- 258017 a cc_ 258117 mn 006300630009 258217 mx 00630063DBFFDFFF 258317 sp -------------------------------- 258418 a ch_ 258518 mn 006300680009 258618 mx 00630068DBFFDFFF 258718 sp -------------------------------- 258819 a aa% 258919 mn 00610061000900090009000900090009 259019 mx 00610061DBFFDFFFDBFFDFFFDBFFDFFF 259119 sp -------------------------------- 259220 a cc% 259320 mn 00630063000900090009000900090009 259420 mx 00630063DBFFDFFFDBFFDFFFDBFFDFFF 259520 sp -------------------------------- 259621 a ch% 259721 mn 00630068000900090009000900090009 259821 mx 00630068DBFFDFFFDBFFDFFFDBFFDFFF 259921 sp -------------------------------- 260022 a aaa 260122 mn 006100610061 260222 mx 006100610061 260322 sp -------------------------------- 260423 a ccc 260523 mn 006300630063 260623 mx 006300630063 260723 sp -------------------------------- 260824 a cch 260924 mn 006300630068 261024 mx 006300630068 261124 sp -------------------------------- 261225 a aaa_ 261325 mn 0061006100610009 261425 mx 006100610061DBFFDFFF 261525 sp -------------------------------- 261626 a ccc_ 261726 mn 0063006300630009 261826 mx 006300630063DBFFDFFF 261926 sp -------------------------------- 262027 a cch_ 262127 mn 0063006300680009 262227 mx 006300630068DBFFDFFF 262327 sp -------------------------------- 262428 a aaa% 262528 mn 00610061006100090009000900090009 262628 mx 006100610061DBFFDFFFDBFFDFFF0000 262728 sp -------------------------------- 262829 a ccc% 262929 mn 00630063006300090009000900090009 263029 mx 006300630063DBFFDFFFDBFFDFFF0000 263129 sp -------------------------------- 263230 a cch% 263330 mn 00630063006800090009000900090009 263430 mx 006300630068DBFFDFFFDBFFDFFF0000 263530 sp -------------------------------- 263631 a aaaaaaaaaaaaaaaaaaaa 263731 mn 0061006100610061 263831 mx 0061006100610061 263931 sp -------------------------------- 264032 a caaaaaaaaaaaaaaaaaaa 264132 mn 0063006100610061 264232 mx 0063006100610061 264332 sp -------------------------------- 2644ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32; 2645SELECT * FROM v1; 2646id name val 26471 a 26481 mn 26491 mx 26501 sp -------------------------------- 26512 a _ 26522 mn 00000000 26532 mx 0000FFFF 26542 sp -------------------------------- 26553 a % 26563 mn 00000000000000000000000000000000 26573 mx 0000FFFF0000FFFF0000FFFF0000FFFF 26583 sp -------------------------------- 26594 a \_ 26604 mn 0000005F 26614 mx 0000005F 26624 sp -------------------------------- 26635 a \% 26645 mn 00000025 26655 mx 00000025 26665 sp -------------------------------- 26676 a \ 26686 mn 0000005C 26696 mx 0000005C 26706 sp -------------------------------- 26717 a a 26727 mn 00000061 26737 mx 00000061 26747 sp -------------------------------- 26758 a c 26768 mn 00000063 26778 mx 00000063 26788 sp -------------------------------- 26799 a a_ 26809 mn 0000006100000000 26819 mx 000000610000FFFF 26829 sp -------------------------------- 268310 a c_ 268410 mn 0000006300000000 268510 mx 000000630000FFFF 268610 sp -------------------------------- 268711 a a% 268811 mn 00000061000000000000000000000000 268911 mx 000000610000FFFF0000FFFF0000FFFF 269011 sp -------------------------------- 269112 a c% 269212 mn 00000063000000000000000000000000 269312 mx 000000630000FFFF0000FFFF0000FFFF 269412 sp -------------------------------- 269513 a aa 269613 mn 0000006100000061 269713 mx 0000006100000061 269813 sp -------------------------------- 269914 a cc 270014 mn 0000006300000063 270114 mx 0000006300000063 270214 sp -------------------------------- 270315 a ch 270415 mn 0000006300000068 270515 mx 0000006300000068 270615 sp -------------------------------- 270716 a aa_ 270816 mn 000000610000006100000000 270916 mx 00000061000000610000FFFF 271016 sp -------------------------------- 271117 a cc_ 271217 mn 000000630000006300000000 271317 mx 00000063000000630000FFFF 271417 sp -------------------------------- 271518 a ch_ 271618 mn 000000630000006800000000 271718 mx 00000063000000680000FFFF 271818 sp -------------------------------- 271919 a aa% 272019 mn 00000061000000610000000000000000 272119 mx 00000061000000610000FFFF0000FFFF 272219 sp -------------------------------- 272320 a cc% 272420 mn 00000063000000630000000000000000 272520 mx 00000063000000630000FFFF0000FFFF 272620 sp -------------------------------- 272721 a ch% 272821 mn 00000063000000680000000000000000 272921 mx 00000063000000680000FFFF0000FFFF 273021 sp -------------------------------- 273122 a aaa 273222 mn 000000610000006100000061 273322 mx 000000610000006100000061 273422 sp -------------------------------- 273523 a ccc 273623 mn 000000630000006300000063 273723 mx 000000630000006300000063 273823 sp -------------------------------- 273924 a cch 274024 mn 000000630000006300000068 274124 mx 000000630000006300000068 274224 sp -------------------------------- 274325 a aaa_ 274425 mn 00000061000000610000006100000000 274525 mx 0000006100000061000000610000FFFF 274625 sp -------------------------------- 274726 a ccc_ 274826 mn 00000063000000630000006300000000 274926 mx 0000006300000063000000630000FFFF 275026 sp -------------------------------- 275127 a cch_ 275227 mn 00000063000000630000006800000000 275327 mx 0000006300000063000000680000FFFF 275427 sp -------------------------------- 275528 a aaa% 275628 mn 00000061000000610000006100000000 275728 mx 0000006100000061000000610000FFFF 275828 sp -------------------------------- 275929 a ccc% 276029 mn 00000063000000630000006300000000 276129 mx 0000006300000063000000630000FFFF 276229 sp -------------------------------- 276330 a cch% 276430 mn 00000063000000630000006800000000 276530 mx 0000006300000063000000680000FFFF 276630 sp -------------------------------- 276731 a aaaaaaaaaaaaaaaaaaaa 276831 mn 00000061000000610000006100000061 276931 mx 00000061000000610000006100000061 277031 sp -------------------------------- 277132 a caaaaaaaaaaaaaaaaaaa 277232 mn 00000063000000610000006100000061 277332 mx 00000063000000610000006100000061 277432 sp -------------------------------- 2775ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_unicode_ci; 2776SELECT * FROM v1; 2777id name val 27781 a 27791 mn 27801 mx 27811 sp -------------------------------- 27822 a _ 27832 mn 00000009 27842 mx 0000FFFF 27852 sp -------------------------------- 27863 a % 27873 mn 00000009000000090000000900000009 27883 mx 0000FFFF0000FFFF0000FFFF0000FFFF 27893 sp -------------------------------- 27904 a \_ 27914 mn 0000005F 27924 mx 0000005F 27934 sp -------------------------------- 27945 a \% 27955 mn 00000025 27965 mx 00000025 27975 sp -------------------------------- 27986 a \ 27996 mn 0000005C 28006 mx 0000005C 28016 sp -------------------------------- 28027 a a 28037 mn 00000061 28047 mx 00000061 28057 sp -------------------------------- 28068 a c 28078 mn 00000063 28088 mx 00000063 28098 sp -------------------------------- 28109 a a_ 28119 mn 0000006100000009 28129 mx 000000610000FFFF 28139 sp -------------------------------- 281410 a c_ 281510 mn 0000006300000009 281610 mx 000000630000FFFF 281710 sp -------------------------------- 281811 a a% 281911 mn 00000061000000090000000900000009 282011 mx 000000610000FFFF0000FFFF0000FFFF 282111 sp -------------------------------- 282212 a c% 282312 mn 00000063000000090000000900000009 282412 mx 000000630000FFFF0000FFFF0000FFFF 282512 sp -------------------------------- 282613 a aa 282713 mn 0000006100000061 282813 mx 0000006100000061 282913 sp -------------------------------- 283014 a cc 283114 mn 0000006300000063 283214 mx 0000006300000063 283314 sp -------------------------------- 283415 a ch 283515 mn 0000006300000068 283615 mx 0000006300000068 283715 sp -------------------------------- 283816 a aa_ 283916 mn 000000610000006100000009 284016 mx 00000061000000610000FFFF 284116 sp -------------------------------- 284217 a cc_ 284317 mn 000000630000006300000009 284417 mx 00000063000000630000FFFF 284517 sp -------------------------------- 284618 a ch_ 284718 mn 000000630000006800000009 284818 mx 00000063000000680000FFFF 284918 sp -------------------------------- 285019 a aa% 285119 mn 00000061000000610000000900000009 285219 mx 00000061000000610000FFFF0000FFFF 285319 sp -------------------------------- 285420 a cc% 285520 mn 00000063000000630000000900000009 285620 mx 00000063000000630000FFFF0000FFFF 285720 sp -------------------------------- 285821 a ch% 285921 mn 00000063000000680000000900000009 286021 mx 00000063000000680000FFFF0000FFFF 286121 sp -------------------------------- 286222 a aaa 286322 mn 000000610000006100000061 286422 mx 000000610000006100000061 286522 sp -------------------------------- 286623 a ccc 286723 mn 000000630000006300000063 286823 mx 000000630000006300000063 286923 sp -------------------------------- 287024 a cch 287124 mn 000000630000006300000068 287224 mx 000000630000006300000068 287324 sp -------------------------------- 287425 a aaa_ 287525 mn 00000061000000610000006100000009 287625 mx 0000006100000061000000610000FFFF 287725 sp -------------------------------- 287826 a ccc_ 287926 mn 00000063000000630000006300000009 288026 mx 0000006300000063000000630000FFFF 288126 sp -------------------------------- 288227 a cch_ 288327 mn 00000063000000630000006800000009 288427 mx 0000006300000063000000680000FFFF 288527 sp -------------------------------- 288628 a aaa% 288728 mn 00000061000000610000006100000009 288828 mx 0000006100000061000000610000FFFF 288928 sp -------------------------------- 289029 a ccc% 289129 mn 00000063000000630000006300000009 289229 mx 0000006300000063000000630000FFFF 289329 sp -------------------------------- 289430 a cch% 289530 mn 00000063000000630000006800000009 289630 mx 0000006300000063000000680000FFFF 289730 sp -------------------------------- 289831 a aaaaaaaaaaaaaaaaaaaa 289931 mn 00000061000000610000006100000061 290031 mx 00000061000000610000006100000061 290131 sp -------------------------------- 290232 a caaaaaaaaaaaaaaaaaaa 290332 mn 00000063000000610000006100000061 290432 mx 00000063000000610000006100000061 290532 sp -------------------------------- 2906ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_czech_ci; 2907SELECT * FROM v1; 2908id name val 29091 a 29101 mn 29111 mx 29121 sp -------------------------------- 29132 a _ 29142 mn 00000009 29152 mx 0000FFFF 29162 sp -------------------------------- 29173 a % 29183 mn 00000009000000090000000900000009 29193 mx 0000FFFF0000FFFF0000FFFF0000FFFF 29203 sp -------------------------------- 29214 a \_ 29224 mn 0000005F 29234 mx 0000005F 29244 sp -------------------------------- 29255 a \% 29265 mn 00000025 29275 mx 00000025 29285 sp -------------------------------- 29296 a \ 29306 mn 0000005C 29316 mx 0000005C 29326 sp -------------------------------- 29337 a a 29347 mn 00000061 29357 mx 00000061 29367 sp -------------------------------- 29378 a c 29388 mn 00000063 29398 mx 00000063 29408 sp -------------------------------- 29419 a a_ 29429 mn 0000006100000009 29439 mx 000000610000FFFF 29449 sp -------------------------------- 294510 a c_ 294610 mn 00000009000000090000000900000009 294710 mx 0000FFFF0000FFFF0000FFFF0000FFFF 294810 sp -------------------------------- 294911 a a% 295011 mn 00000061000000090000000900000009 295111 mx 000000610000FFFF0000FFFF0000FFFF 295211 sp -------------------------------- 295312 a c% 295412 mn 00000009000000090000000900000009 295512 mx 0000FFFF0000FFFF0000FFFF0000FFFF 295612 sp -------------------------------- 295713 a aa 295813 mn 0000006100000061 295913 mx 0000006100000061 296013 sp -------------------------------- 296114 a cc 296214 mn 0000006300000063 296314 mx 0000006300000063 296414 sp -------------------------------- 296515 a ch 296615 mn 0000006300000068 296715 mx 0000006300000068 296815 sp -------------------------------- 296916 a aa_ 297016 mn 000000610000006100000009 297116 mx 00000061000000610000FFFF 297216 sp -------------------------------- 297317 a cc_ 297417 mn 00000063000000090000000900000009 297517 mx 000000630000FFFF0000FFFF0000FFFF 297617 sp -------------------------------- 297718 a ch_ 297818 mn 000000630000006800000009 297918 mx 00000063000000680000FFFF 298018 sp -------------------------------- 298119 a aa% 298219 mn 00000061000000610000000900000009 298319 mx 00000061000000610000FFFF0000FFFF 298419 sp -------------------------------- 298520 a cc% 298620 mn 00000063000000090000000900000009 298720 mx 000000630000FFFF0000FFFF0000FFFF 298820 sp -------------------------------- 298921 a ch% 299021 mn 00000063000000680000000900000009 299121 mx 00000063000000680000FFFF0000FFFF 299221 sp -------------------------------- 299322 a aaa 299422 mn 000000610000006100000061 299522 mx 000000610000006100000061 299622 sp -------------------------------- 299723 a ccc 299823 mn 000000630000006300000063 299923 mx 000000630000006300000063 300023 sp -------------------------------- 300124 a cch 300224 mn 000000630000006300000068 300324 mx 000000630000006300000068 300424 sp -------------------------------- 300525 a aaa_ 300625 mn 00000061000000610000006100000009 300725 mx 0000006100000061000000610000FFFF 300825 sp -------------------------------- 300926 a ccc_ 301026 mn 00000063000000630000000900000009 301126 mx 00000063000000630000FFFF0000FFFF 301226 sp -------------------------------- 301327 a cch_ 301427 mn 00000063000000630000006800000009 301527 mx 0000006300000063000000680000FFFF 301627 sp -------------------------------- 301728 a aaa% 301828 mn 00000061000000610000006100000009 301928 mx 0000006100000061000000610000FFFF 302028 sp -------------------------------- 302129 a ccc% 302229 mn 00000063000000630000000900000009 302329 mx 00000063000000630000FFFF0000FFFF 302429 sp -------------------------------- 302530 a cch% 302630 mn 00000063000000630000006800000009 302730 mx 0000006300000063000000680000FFFF 302830 sp -------------------------------- 302931 a aaaaaaaaaaaaaaaaaaaa 303031 mn 00000061000000610000006100000061 303131 mx 00000061000000610000006100000061 303231 sp -------------------------------- 303332 a caaaaaaaaaaaaaaaaaaa 303432 mn 00000063000000610000006100000061 303532 mx 00000063000000610000006100000061 303632 sp -------------------------------- 3037ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_danish_ci; 3038SELECT * FROM v1; 3039id name val 30401 a 30411 mn 30421 mx 30431 sp -------------------------------- 30442 a _ 30452 mn 00000009 30462 mx 0000FFFF 30472 sp -------------------------------- 30483 a % 30493 mn 00000009000000090000000900000009 30503 mx 0000FFFF0000FFFF0000FFFF0000FFFF 30513 sp -------------------------------- 30524 a \_ 30534 mn 0000005F 30544 mx 0000005F 30554 sp -------------------------------- 30565 a \% 30575 mn 00000025 30585 mx 00000025 30595 sp -------------------------------- 30606 a \ 30616 mn 0000005C 30626 mx 0000005C 30636 sp -------------------------------- 30647 a a 30657 mn 00000061 30667 mx 00000061 30677 sp -------------------------------- 30688 a c 30698 mn 00000063 30708 mx 00000063 30718 sp -------------------------------- 30729 a a_ 30739 mn 00000009000000090000000900000009 30749 mx 0000FFFF0000FFFF0000FFFF0000FFFF 30759 sp -------------------------------- 307610 a c_ 307710 mn 0000006300000009 307810 mx 000000630000FFFF 307910 sp -------------------------------- 308011 a a% 308111 mn 00000009000000090000000900000009 308211 mx 0000FFFF0000FFFF0000FFFF0000FFFF 308311 sp -------------------------------- 308412 a c% 308512 mn 00000063000000090000000900000009 308612 mx 000000630000FFFF0000FFFF0000FFFF 308712 sp -------------------------------- 308813 a aa 308913 mn 0000006100000061 309013 mx 0000006100000061 309113 sp -------------------------------- 309214 a cc 309314 mn 0000006300000063 309414 mx 0000006300000063 309514 sp -------------------------------- 309615 a ch 309715 mn 0000006300000068 309815 mx 0000006300000068 309915 sp -------------------------------- 310016 a aa_ 310116 mn 000000610000006100000009 310216 mx 00000061000000610000FFFF 310316 sp -------------------------------- 310417 a cc_ 310517 mn 000000630000006300000009 310617 mx 00000063000000630000FFFF 310717 sp -------------------------------- 310818 a ch_ 310918 mn 000000630000006800000009 311018 mx 00000063000000680000FFFF 311118 sp -------------------------------- 311219 a aa% 311319 mn 00000061000000610000000900000009 311419 mx 00000061000000610000FFFF0000FFFF 311519 sp -------------------------------- 311620 a cc% 311720 mn 00000063000000630000000900000009 311820 mx 00000063000000630000FFFF0000FFFF 311920 sp -------------------------------- 312021 a ch% 312121 mn 00000063000000680000000900000009 312221 mx 00000063000000680000FFFF0000FFFF 312321 sp -------------------------------- 312422 a aaa 312522 mn 000000610000006100000061 312622 mx 000000610000006100000061 312722 sp -------------------------------- 312823 a ccc 312923 mn 000000630000006300000063 313023 mx 000000630000006300000063 313123 sp -------------------------------- 313224 a cch 313324 mn 000000630000006300000068 313424 mx 000000630000006300000068 313524 sp -------------------------------- 313625 a aaa_ 313725 mn 00000061000000610000000900000009 313825 mx 00000061000000610000FFFF0000FFFF 313925 sp -------------------------------- 314026 a ccc_ 314126 mn 00000063000000630000006300000009 314226 mx 0000006300000063000000630000FFFF 314326 sp -------------------------------- 314427 a cch_ 314527 mn 00000063000000630000006800000009 314627 mx 0000006300000063000000680000FFFF 314727 sp -------------------------------- 314828 a aaa% 314928 mn 00000061000000610000000900000009 315028 mx 00000061000000610000FFFF0000FFFF 315128 sp -------------------------------- 315229 a ccc% 315329 mn 00000063000000630000006300000009 315429 mx 0000006300000063000000630000FFFF 315529 sp -------------------------------- 315630 a cch% 315730 mn 00000063000000630000006800000009 315830 mx 0000006300000063000000680000FFFF 315930 sp -------------------------------- 316031 a aaaaaaaaaaaaaaaaaaaa 316131 mn 00000061000000610000006100000061 316231 mx 00000061000000610000006100000061 316331 sp -------------------------------- 316432 a caaaaaaaaaaaaaaaaaaa 316532 mn 00000063000000610000006100000009 316632 mx 0000006300000061000000610000FFFF 316732 sp -------------------------------- 3168ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_unicode_520_ci; 3169SELECT * FROM v1; 3170id name val 31711 a 31721 mn 31731 mx 31741 sp -------------------------------- 31752 a _ 31762 mn 00000009 31772 mx 0010FFFF 31782 sp -------------------------------- 31793 a % 31803 mn 00000009000000090000000900000009 31813 mx 0010FFFF0010FFFF0010FFFF0010FFFF 31823 sp -------------------------------- 31834 a \_ 31844 mn 0000005F 31854 mx 0000005F 31864 sp -------------------------------- 31875 a \% 31885 mn 00000025 31895 mx 00000025 31905 sp -------------------------------- 31916 a \ 31926 mn 0000005C 31936 mx 0000005C 31946 sp -------------------------------- 31957 a a 31967 mn 00000061 31977 mx 00000061 31987 sp -------------------------------- 31998 a c 32008 mn 00000063 32018 mx 00000063 32028 sp -------------------------------- 32039 a a_ 32049 mn 0000006100000009 32059 mx 000000610010FFFF 32069 sp -------------------------------- 320710 a c_ 320810 mn 0000006300000009 320910 mx 000000630010FFFF 321010 sp -------------------------------- 321111 a a% 321211 mn 00000061000000090000000900000009 321311 mx 000000610010FFFF0010FFFF0010FFFF 321411 sp -------------------------------- 321512 a c% 321612 mn 00000063000000090000000900000009 321712 mx 000000630010FFFF0010FFFF0010FFFF 321812 sp -------------------------------- 321913 a aa 322013 mn 0000006100000061 322113 mx 0000006100000061 322213 sp -------------------------------- 322314 a cc 322414 mn 0000006300000063 322514 mx 0000006300000063 322614 sp -------------------------------- 322715 a ch 322815 mn 0000006300000068 322915 mx 0000006300000068 323015 sp -------------------------------- 323116 a aa_ 323216 mn 000000610000006100000009 323316 mx 00000061000000610010FFFF 323416 sp -------------------------------- 323517 a cc_ 323617 mn 000000630000006300000009 323717 mx 00000063000000630010FFFF 323817 sp -------------------------------- 323918 a ch_ 324018 mn 000000630000006800000009 324118 mx 00000063000000680010FFFF 324218 sp -------------------------------- 324319 a aa% 324419 mn 00000061000000610000000900000009 324519 mx 00000061000000610010FFFF0010FFFF 324619 sp -------------------------------- 324720 a cc% 324820 mn 00000063000000630000000900000009 324920 mx 00000063000000630010FFFF0010FFFF 325020 sp -------------------------------- 325121 a ch% 325221 mn 00000063000000680000000900000009 325321 mx 00000063000000680010FFFF0010FFFF 325421 sp -------------------------------- 325522 a aaa 325622 mn 000000610000006100000061 325722 mx 000000610000006100000061 325822 sp -------------------------------- 325923 a ccc 326023 mn 000000630000006300000063 326123 mx 000000630000006300000063 326223 sp -------------------------------- 326324 a cch 326424 mn 000000630000006300000068 326524 mx 000000630000006300000068 326624 sp -------------------------------- 326725 a aaa_ 326825 mn 00000061000000610000006100000009 326925 mx 0000006100000061000000610010FFFF 327025 sp -------------------------------- 327126 a ccc_ 327226 mn 00000063000000630000006300000009 327326 mx 0000006300000063000000630010FFFF 327426 sp -------------------------------- 327527 a cch_ 327627 mn 00000063000000630000006800000009 327727 mx 0000006300000063000000680010FFFF 327827 sp -------------------------------- 327928 a aaa% 328028 mn 00000061000000610000006100000009 328128 mx 0000006100000061000000610010FFFF 328228 sp -------------------------------- 328329 a ccc% 328429 mn 00000063000000630000006300000009 328529 mx 0000006300000063000000630010FFFF 328629 sp -------------------------------- 328730 a cch% 328830 mn 00000063000000630000006800000009 328930 mx 0000006300000063000000680010FFFF 329030 sp -------------------------------- 329131 a aaaaaaaaaaaaaaaaaaaa 329231 mn 00000061000000610000006100000061 329331 mx 00000061000000610000006100000061 329431 sp -------------------------------- 329532 a caaaaaaaaaaaaaaaaaaa 329632 mn 00000063000000610000006100000061 329732 mx 00000063000000610000006100000061 329832 sp -------------------------------- 3299DROP VIEW v1; 3300DROP TABLE t1; 3301