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; 287Warnings: 288Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 289SELECT * FROM v1; 290id name val 2911 a 2921 mn 2931 mx 2941 sp -------------------------------- 2952 a _ 2962 mn 00000000000000000000000000000000 2972 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2982 sp -------------------------------- 2993 a % 3003 mn 00000000000000000000000000000000 3013 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3023 sp -------------------------------- 3034 a \_ 3044 mn 5F 3054 mx 5F 3064 sp -------------------------------- 3075 a \% 3085 mn 25 3095 mx 25 3105 sp -------------------------------- 3116 a \ 3126 mn 5C 3136 mx 5C 3146 sp -------------------------------- 3157 a a 3167 mn 61 3177 mx 61 3187 sp -------------------------------- 3198 a c 3208 mn 63 3218 mx 63 3228 sp -------------------------------- 3239 a a_ 3249 mn 61000000000000000000000000000000 3259 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 3269 sp -------------------------------- 32710 a c_ 32810 mn 63000000000000000000000000000000 32910 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 33010 sp -------------------------------- 33111 a a% 33211 mn 61000000000000000000000000000000 33311 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 33411 sp -------------------------------- 33512 a c% 33612 mn 63000000000000000000000000000000 33712 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 33812 sp -------------------------------- 33913 a aa 34013 mn 6161 34113 mx 6161 34213 sp -------------------------------- 34314 a cc 34414 mn 6363 34514 mx 6363 34614 sp -------------------------------- 34715 a ch 34815 mn 6368 34915 mx 6368 35015 sp -------------------------------- 35116 a aa_ 35216 mn 61610000000000000000000000000000 35316 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 35416 sp -------------------------------- 35517 a cc_ 35617 mn 63630000000000000000000000000000 35717 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 35817 sp -------------------------------- 35918 a ch_ 36018 mn 63680000000000000000000000000000 36118 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 36218 sp -------------------------------- 36319 a aa% 36419 mn 61610000000000000000000000000000 36519 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 36619 sp -------------------------------- 36720 a cc% 36820 mn 63630000000000000000000000000000 36920 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 37020 sp -------------------------------- 37121 a ch% 37221 mn 63680000000000000000000000000000 37321 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 37421 sp -------------------------------- 37522 a aaa 37622 mn 616161 37722 mx 616161 37822 sp -------------------------------- 37923 a ccc 38023 mn 636363 38123 mx 636363 38223 sp -------------------------------- 38324 a cch 38424 mn 636368 38524 mx 636368 38624 sp -------------------------------- 38725 a aaa_ 38825 mn 61616100000000000000000000000000 38925 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 39025 sp -------------------------------- 39126 a ccc_ 39226 mn 63636300000000000000000000000000 39326 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 39426 sp -------------------------------- 39527 a cch_ 39627 mn 63636800000000000000000000000000 39727 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 39827 sp -------------------------------- 39928 a aaa% 40028 mn 61616100000000000000000000000000 40128 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 40228 sp -------------------------------- 40329 a ccc% 40429 mn 63636300000000000000000000000000 40529 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 40629 sp -------------------------------- 40730 a cch% 40830 mn 63636800000000000000000000000000 40930 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 41030 sp -------------------------------- 41131 a aaaaaaaaaaaaaaaaaaaa 41231 mn 6161616161 41331 mx 6161616161 41431 sp -------------------------------- 41532 a caaaaaaaaaaaaaaaaaaa 41632 mn 6361616161 41732 mx 6361616161 41832 sp -------------------------------- 419ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci; 420Warnings: 421Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 422Warning 3778 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 423SELECT * FROM v1; 424id name val 4251 a 4261 mn 4271 mx 4281 sp -------------------------------- 4292 a _ 4302 mn 09090909090909090909090909090909 4312 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 4322 sp -------------------------------- 4333 a % 4343 mn 09090909090909090909090909090909 4353 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 4363 sp -------------------------------- 4374 a \_ 4384 mn 5F 4394 mx 5F 4404 sp -------------------------------- 4415 a \% 4425 mn 25 4435 mx 25 4445 sp -------------------------------- 4456 a \ 4466 mn 5C 4476 mx 5C 4486 sp -------------------------------- 4497 a a 4507 mn 61 4517 mx 61 4527 sp -------------------------------- 4538 a c 4548 mn 63 4558 mx 63 4568 sp -------------------------------- 4579 a a_ 4589 mn 61090909090909090909090909090909 4599 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 4609 sp -------------------------------- 46110 a c_ 46210 mn 63090909090909090909090909090909 46310 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 46410 sp -------------------------------- 46511 a a% 46611 mn 61090909090909090909090909090909 46711 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 46811 sp -------------------------------- 46912 a c% 47012 mn 63090909090909090909090909090909 47112 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 47212 sp -------------------------------- 47313 a aa 47413 mn 6161 47513 mx 6161 47613 sp -------------------------------- 47714 a cc 47814 mn 6363 47914 mx 6363 48014 sp -------------------------------- 48115 a ch 48215 mn 6368 48315 mx 6368 48415 sp -------------------------------- 48516 a aa_ 48616 mn 61610909090909090909090909090909 48716 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 48816 sp -------------------------------- 48917 a cc_ 49017 mn 63630909090909090909090909090909 49117 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 49217 sp -------------------------------- 49318 a ch_ 49418 mn 63680909090909090909090909090909 49518 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 49618 sp -------------------------------- 49719 a aa% 49819 mn 61610909090909090909090909090909 49919 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 50019 sp -------------------------------- 50120 a cc% 50220 mn 63630909090909090909090909090909 50320 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 50420 sp -------------------------------- 50521 a ch% 50621 mn 63680909090909090909090909090909 50721 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 50821 sp -------------------------------- 50922 a aaa 51022 mn 616161 51122 mx 616161 51222 sp -------------------------------- 51323 a ccc 51423 mn 636363 51523 mx 636363 51623 sp -------------------------------- 51724 a cch 51824 mn 636368 51924 mx 636368 52024 sp -------------------------------- 52125 a aaa_ 52225 mn 61616109090909090909090909090909 52325 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 52425 sp -------------------------------- 52526 a ccc_ 52626 mn 63636309090909090909090909090909 52726 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 52826 sp -------------------------------- 52927 a cch_ 53027 mn 63636809090909090909090909090909 53127 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 53227 sp -------------------------------- 53328 a aaa% 53428 mn 61616109090909090909090909090909 53528 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 53628 sp -------------------------------- 53729 a ccc% 53829 mn 63636309090909090909090909090909 53929 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 54029 sp -------------------------------- 54130 a cch% 54230 mn 63636809090909090909090909090909 54330 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 54430 sp -------------------------------- 54531 a aaaaaaaaaaaaaaaaaaaa 54631 mn 6161616161 54731 mx 6161616161 54831 sp -------------------------------- 54932 a caaaaaaaaaaaaaaaaaaa 55032 mn 6361616161 55132 mx 6361616161 55232 sp -------------------------------- 553ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_czech_ci; 554Warnings: 555Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 556Warning 3778 'utf8_czech_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 557SELECT * FROM v1; 558id name val 5591 a 5601 mn 5611 mx 5621 sp -------------------------------- 5632 a _ 5642 mn 09090909090909090909090909090909 5652 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 5662 sp -------------------------------- 5673 a % 5683 mn 09090909090909090909090909090909 5693 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 5703 sp -------------------------------- 5714 a \_ 5724 mn 5F 5734 mx 5F 5744 sp -------------------------------- 5755 a \% 5765 mn 25 5775 mx 25 5785 sp -------------------------------- 5796 a \ 5806 mn 5C 5816 mx 5C 5826 sp -------------------------------- 5837 a a 5847 mn 61 5857 mx 61 5867 sp -------------------------------- 5878 a c 5888 mn 63 5898 mx 63 5908 sp -------------------------------- 5919 a a_ 5929 mn 61090909090909090909090909090909 5939 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 5949 sp -------------------------------- 59510 a c_ 59610 mn 09090909090909090909090909090909 59710 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 59810 sp -------------------------------- 59911 a a% 60011 mn 61090909090909090909090909090909 60111 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 60211 sp -------------------------------- 60312 a c% 60412 mn 09090909090909090909090909090909 60512 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 60612 sp -------------------------------- 60713 a aa 60813 mn 6161 60913 mx 6161 61013 sp -------------------------------- 61114 a cc 61214 mn 6363 61314 mx 6363 61414 sp -------------------------------- 61515 a ch 61615 mn 6368 61715 mx 6368 61815 sp -------------------------------- 61916 a aa_ 62016 mn 61610909090909090909090909090909 62116 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 62216 sp -------------------------------- 62317 a cc_ 62417 mn 63090909090909090909090909090909 62517 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 62617 sp -------------------------------- 62718 a ch_ 62818 mn 63680909090909090909090909090909 62918 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 63018 sp -------------------------------- 63119 a aa% 63219 mn 61610909090909090909090909090909 63319 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 63419 sp -------------------------------- 63520 a cc% 63620 mn 63090909090909090909090909090909 63720 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 63820 sp -------------------------------- 63921 a ch% 64021 mn 63680909090909090909090909090909 64121 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 64221 sp -------------------------------- 64322 a aaa 64422 mn 616161 64522 mx 616161 64622 sp -------------------------------- 64723 a ccc 64823 mn 636363 64923 mx 636363 65023 sp -------------------------------- 65124 a cch 65224 mn 636368 65324 mx 636368 65424 sp -------------------------------- 65525 a aaa_ 65625 mn 61616109090909090909090909090909 65725 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 65825 sp -------------------------------- 65926 a ccc_ 66026 mn 63630909090909090909090909090909 66126 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 66226 sp -------------------------------- 66327 a cch_ 66427 mn 63636809090909090909090909090909 66527 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 66627 sp -------------------------------- 66728 a aaa% 66828 mn 61616109090909090909090909090909 66928 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 67028 sp -------------------------------- 67129 a ccc% 67229 mn 63630909090909090909090909090909 67329 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 67429 sp -------------------------------- 67530 a cch% 67630 mn 63636809090909090909090909090909 67730 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 67830 sp -------------------------------- 67931 a aaaaaaaaaaaaaaaaaaaa 68031 mn 6161616161 68131 mx 6161616161 68231 sp -------------------------------- 68332 a caaaaaaaaaaaaaaaaaaa 68432 mn 6361616161 68532 mx 6361616161 68632 sp -------------------------------- 687ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_danish_ci; 688Warnings: 689Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 690Warning 3778 'utf8_danish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 691SELECT * FROM v1; 692id name val 6931 a 6941 mn 6951 mx 6961 sp -------------------------------- 6972 a _ 6982 mn 09090909090909090909090909090909 6992 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 7002 sp -------------------------------- 7013 a % 7023 mn 09090909090909090909090909090909 7033 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 7043 sp -------------------------------- 7054 a \_ 7064 mn 5F 7074 mx 5F 7084 sp -------------------------------- 7095 a \% 7105 mn 25 7115 mx 25 7125 sp -------------------------------- 7136 a \ 7146 mn 5C 7156 mx 5C 7166 sp -------------------------------- 7177 a a 7187 mn 61 7197 mx 61 7207 sp -------------------------------- 7218 a c 7228 mn 63 7238 mx 63 7248 sp -------------------------------- 7259 a a_ 7269 mn 09090909090909090909090909090909 7279 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 7289 sp -------------------------------- 72910 a c_ 73010 mn 63090909090909090909090909090909 73110 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 73210 sp -------------------------------- 73311 a a% 73411 mn 09090909090909090909090909090909 73511 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 73611 sp -------------------------------- 73712 a c% 73812 mn 63090909090909090909090909090909 73912 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 74012 sp -------------------------------- 74113 a aa 74213 mn 6161 74313 mx 6161 74413 sp -------------------------------- 74514 a cc 74614 mn 6363 74714 mx 6363 74814 sp -------------------------------- 74915 a ch 75015 mn 6368 75115 mx 6368 75215 sp -------------------------------- 75316 a aa_ 75416 mn 61610909090909090909090909090909 75516 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 75616 sp -------------------------------- 75717 a cc_ 75817 mn 63630909090909090909090909090909 75917 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 76017 sp -------------------------------- 76118 a ch_ 76218 mn 63680909090909090909090909090909 76318 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 76418 sp -------------------------------- 76519 a aa% 76619 mn 61610909090909090909090909090909 76719 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 76819 sp -------------------------------- 76920 a cc% 77020 mn 63630909090909090909090909090909 77120 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 77220 sp -------------------------------- 77321 a ch% 77421 mn 63680909090909090909090909090909 77521 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 77621 sp -------------------------------- 77722 a aaa 77822 mn 616161 77922 mx 616161 78022 sp -------------------------------- 78123 a ccc 78223 mn 636363 78323 mx 636363 78423 sp -------------------------------- 78524 a cch 78624 mn 636368 78724 mx 636368 78824 sp -------------------------------- 78925 a aaa_ 79025 mn 61610909090909090909090909090909 79125 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 79225 sp -------------------------------- 79326 a ccc_ 79426 mn 63636309090909090909090909090909 79526 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 79626 sp -------------------------------- 79727 a cch_ 79827 mn 63636809090909090909090909090909 79927 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 80027 sp -------------------------------- 80128 a aaa% 80228 mn 61610909090909090909090909090909 80328 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 80428 sp -------------------------------- 80529 a ccc% 80629 mn 63636309090909090909090909090909 80729 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 80829 sp -------------------------------- 80930 a cch% 81030 mn 63636809090909090909090909090909 81130 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 81230 sp -------------------------------- 81331 a aaaaaaaaaaaaaaaaaaaa 81431 mn 61616161090909090909090909090909 81531 mx 61616161EFBFBFEFBFBFEFBFBFEFBFBF 81631 sp -------------------------------- 81732 a caaaaaaaaaaaaaaaaaaa 81832 mn 6361616161 81932 mx 6361616161 82032 sp -------------------------------- 821ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4; 822SELECT * FROM v1; 823id name val 8241 a 8251 mn 8261 mx 8271 sp -------------------------------- 8282 a _ 8292 mn 8302 mx F48FBFBFF48FBFBFF48FBFBFF48FBFBF 8312 sp -------------------------------- 8323 a % 8333 mn 8343 mx F48FBFBFF48FBFBFF48FBFBFF48FBFBF 8353 sp -------------------------------- 8364 a \_ 8374 mn 5F 8384 mx 5F 8394 sp -------------------------------- 8405 a \% 8415 mn 25 8425 mx 25 8435 sp -------------------------------- 8446 a \ 8456 mn 5C 8466 mx 5C 8476 sp -------------------------------- 8487 a a 8497 mn 61 8507 mx 61 8517 sp -------------------------------- 8528 a c 8538 mn 63 8548 mx 63 8558 sp -------------------------------- 8569 a a_ 8579 mn 61 8589 mx 61F48FBFBFF48FBFBFF48FBFBF202020 8599 sp -------------------------------- 86010 a c_ 86110 mn 63 86210 mx 63F48FBFBFF48FBFBFF48FBFBF202020 86310 sp -------------------------------- 86411 a a% 86511 mn 61 86611 mx 61F48FBFBFF48FBFBFF48FBFBF202020 86711 sp -------------------------------- 86812 a c% 86912 mn 63 87012 mx 63F48FBFBFF48FBFBFF48FBFBF202020 87112 sp -------------------------------- 87213 a aa 87313 mn 6161 87413 mx 6161 87513 sp -------------------------------- 87614 a cc 87714 mn 6363 87814 mx 6363 87914 sp -------------------------------- 88015 a ch 88115 mn 6368 88215 mx 6368 88315 sp -------------------------------- 88416 a aa_ 88516 mn 6161 88616 mx 6161F48FBFBFF48FBFBFF48FBFBF2020 88716 sp -------------------------------- 88817 a cc_ 88917 mn 6363 89017 mx 6363F48FBFBFF48FBFBFF48FBFBF2020 89117 sp -------------------------------- 89218 a ch_ 89318 mn 6368 89418 mx 6368F48FBFBFF48FBFBFF48FBFBF2020 89518 sp -------------------------------- 89619 a aa% 89719 mn 6161 89819 mx 6161F48FBFBFF48FBFBFF48FBFBF2020 89919 sp -------------------------------- 90020 a cc% 90120 mn 6363 90220 mx 6363F48FBFBFF48FBFBFF48FBFBF2020 90320 sp -------------------------------- 90421 a ch% 90521 mn 6368 90621 mx 6368F48FBFBFF48FBFBFF48FBFBF2020 90721 sp -------------------------------- 90822 a aaa 90922 mn 616161 91022 mx 616161 91122 sp -------------------------------- 91223 a ccc 91323 mn 636363 91423 mx 636363 91523 sp -------------------------------- 91624 a cch 91724 mn 636368 91824 mx 636368 91924 sp -------------------------------- 92025 a aaa_ 92125 mn 616161 92225 mx 616161F48FBFBFF48FBFBFF48FBFBF20 92325 sp -------------------------------- 92426 a ccc_ 92526 mn 636363 92626 mx 636363F48FBFBFF48FBFBFF48FBFBF20 92726 sp -------------------------------- 92827 a cch_ 92927 mn 636368 93027 mx 636368F48FBFBFF48FBFBFF48FBFBF20 93127 sp -------------------------------- 93228 a aaa% 93328 mn 616161 93428 mx 616161F48FBFBFF48FBFBFF48FBFBF20 93528 sp -------------------------------- 93629 a ccc% 93729 mn 636363 93829 mx 636363F48FBFBFF48FBFBFF48FBFBF20 93929 sp -------------------------------- 94030 a cch% 94130 mn 636368 94230 mx 636368F48FBFBFF48FBFBFF48FBFBF20 94330 sp -------------------------------- 94431 a aaaaaaaaaaaaaaaaaaaa 94531 mn 61616161 94631 mx 61616161 94731 sp -------------------------------- 94832 a caaaaaaaaaaaaaaaaaaa 94932 mn 63616161 95032 mx 63616161 95132 sp -------------------------------- 952ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 953SELECT * FROM v1; 954id name val 9551 a 9561 mn 9571 mx 9581 sp -------------------------------- 9592 a _ 9602 mn 09090909090909090909090909090909 9612 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 9622 sp -------------------------------- 9633 a % 9643 mn 09090909090909090909090909090909 9653 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 9663 sp -------------------------------- 9674 a \_ 9684 mn 5F 9694 mx 5F 9704 sp -------------------------------- 9715 a \% 9725 mn 25 9735 mx 25 9745 sp -------------------------------- 9756 a \ 9766 mn 5C 9776 mx 5C 9786 sp -------------------------------- 9797 a a 9807 mn 61 9817 mx 61 9827 sp -------------------------------- 9838 a c 9848 mn 63 9858 mx 63 9868 sp -------------------------------- 9879 a a_ 9889 mn 61090909090909090909090909090909 9899 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 9909 sp -------------------------------- 99110 a c_ 99210 mn 63090909090909090909090909090909 99310 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 99410 sp -------------------------------- 99511 a a% 99611 mn 61090909090909090909090909090909 99711 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 99811 sp -------------------------------- 99912 a c% 100012 mn 63090909090909090909090909090909 100112 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 100212 sp -------------------------------- 100313 a aa 100413 mn 6161 100513 mx 6161 100613 sp -------------------------------- 100714 a cc 100814 mn 6363 100914 mx 6363 101014 sp -------------------------------- 101115 a ch 101215 mn 6368 101315 mx 6368 101415 sp -------------------------------- 101516 a aa_ 101616 mn 61610909090909090909090909090909 101716 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 101816 sp -------------------------------- 101917 a cc_ 102017 mn 63630909090909090909090909090909 102117 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 102217 sp -------------------------------- 102318 a ch_ 102418 mn 63680909090909090909090909090909 102518 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 102618 sp -------------------------------- 102719 a aa% 102819 mn 61610909090909090909090909090909 102919 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 103019 sp -------------------------------- 103120 a cc% 103220 mn 63630909090909090909090909090909 103320 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 103420 sp -------------------------------- 103521 a ch% 103621 mn 63680909090909090909090909090909 103721 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 103821 sp -------------------------------- 103922 a aaa 104022 mn 616161 104122 mx 616161 104222 sp -------------------------------- 104323 a ccc 104423 mn 636363 104523 mx 636363 104623 sp -------------------------------- 104724 a cch 104824 mn 636368 104924 mx 636368 105024 sp -------------------------------- 105125 a aaa_ 105225 mn 61616109090909090909090909090909 105325 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 105425 sp -------------------------------- 105526 a ccc_ 105626 mn 63636309090909090909090909090909 105726 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 105826 sp -------------------------------- 105927 a cch_ 106027 mn 63636809090909090909090909090909 106127 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 106227 sp -------------------------------- 106328 a aaa% 106428 mn 61616109090909090909090909090909 106528 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 106628 sp -------------------------------- 106729 a ccc% 106829 mn 63636309090909090909090909090909 106929 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 107029 sp -------------------------------- 107130 a cch% 107230 mn 63636809090909090909090909090909 107330 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 107430 sp -------------------------------- 107531 a aaaaaaaaaaaaaaaaaaaa 107631 mn 61616161 107731 mx 61616161 107831 sp -------------------------------- 107932 a caaaaaaaaaaaaaaaaaaa 108032 mn 63616161 108132 mx 63616161 108232 sp -------------------------------- 1083ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci; 1084SELECT * FROM v1; 1085id name val 10861 a 10871 mn 10881 mx 10891 sp -------------------------------- 10902 a _ 10912 mn 09090909090909090909090909090909 10922 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 10932 sp -------------------------------- 10943 a % 10953 mn 09090909090909090909090909090909 10963 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 10973 sp -------------------------------- 10984 a \_ 10994 mn 5F 11004 mx 5F 11014 sp -------------------------------- 11025 a \% 11035 mn 25 11045 mx 25 11055 sp -------------------------------- 11066 a \ 11076 mn 5C 11086 mx 5C 11096 sp -------------------------------- 11107 a a 11117 mn 61 11127 mx 61 11137 sp -------------------------------- 11148 a c 11158 mn 63 11168 mx 63 11178 sp -------------------------------- 11189 a a_ 11199 mn 61090909090909090909090909090909 11209 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 11219 sp -------------------------------- 112210 a c_ 112310 mn 09090909090909090909090909090909 112410 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 112510 sp -------------------------------- 112611 a a% 112711 mn 61090909090909090909090909090909 112811 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 112911 sp -------------------------------- 113012 a c% 113112 mn 09090909090909090909090909090909 113212 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 113312 sp -------------------------------- 113413 a aa 113513 mn 6161 113613 mx 6161 113713 sp -------------------------------- 113814 a cc 113914 mn 6363 114014 mx 6363 114114 sp -------------------------------- 114215 a ch 114315 mn 6368 114415 mx 6368 114515 sp -------------------------------- 114616 a aa_ 114716 mn 61610909090909090909090909090909 114816 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 114916 sp -------------------------------- 115017 a cc_ 115117 mn 63090909090909090909090909090909 115217 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 115317 sp -------------------------------- 115418 a ch_ 115518 mn 63680909090909090909090909090909 115618 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 115718 sp -------------------------------- 115819 a aa% 115919 mn 61610909090909090909090909090909 116019 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 116119 sp -------------------------------- 116220 a cc% 116320 mn 63090909090909090909090909090909 116420 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 116520 sp -------------------------------- 116621 a ch% 116721 mn 63680909090909090909090909090909 116821 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 116921 sp -------------------------------- 117022 a aaa 117122 mn 616161 117222 mx 616161 117322 sp -------------------------------- 117423 a ccc 117523 mn 636363 117623 mx 636363 117723 sp -------------------------------- 117824 a cch 117924 mn 636368 118024 mx 636368 118124 sp -------------------------------- 118225 a aaa_ 118325 mn 61616109090909090909090909090909 118425 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 118525 sp -------------------------------- 118626 a ccc_ 118726 mn 63630909090909090909090909090909 118826 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 118926 sp -------------------------------- 119027 a cch_ 119127 mn 63636809090909090909090909090909 119227 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 119327 sp -------------------------------- 119428 a aaa% 119528 mn 61616109090909090909090909090909 119628 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 119728 sp -------------------------------- 119829 a ccc% 119929 mn 63630909090909090909090909090909 120029 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 120129 sp -------------------------------- 120230 a cch% 120330 mn 63636809090909090909090909090909 120430 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 120530 sp -------------------------------- 120631 a aaaaaaaaaaaaaaaaaaaa 120731 mn 61616161 120831 mx 61616161 120931 sp -------------------------------- 121032 a caaaaaaaaaaaaaaaaaaa 121132 mn 63616161 121232 mx 63616161 121332 sp -------------------------------- 1214ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci; 1215SELECT * FROM v1; 1216id name val 12171 a 12181 mn 12191 mx 12201 sp -------------------------------- 12212 a _ 12222 mn 09090909090909090909090909090909 12232 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 12242 sp -------------------------------- 12253 a % 12263 mn 09090909090909090909090909090909 12273 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 12283 sp -------------------------------- 12294 a \_ 12304 mn 5F 12314 mx 5F 12324 sp -------------------------------- 12335 a \% 12345 mn 25 12355 mx 25 12365 sp -------------------------------- 12376 a \ 12386 mn 5C 12396 mx 5C 12406 sp -------------------------------- 12417 a a 12427 mn 61 12437 mx 61 12447 sp -------------------------------- 12458 a c 12468 mn 63 12478 mx 63 12488 sp -------------------------------- 12499 a a_ 12509 mn 09090909090909090909090909090909 12519 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 12529 sp -------------------------------- 125310 a c_ 125410 mn 63090909090909090909090909090909 125510 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 125610 sp -------------------------------- 125711 a a% 125811 mn 09090909090909090909090909090909 125911 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 126011 sp -------------------------------- 126112 a c% 126212 mn 63090909090909090909090909090909 126312 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 126412 sp -------------------------------- 126513 a aa 126613 mn 6161 126713 mx 6161 126813 sp -------------------------------- 126914 a cc 127014 mn 6363 127114 mx 6363 127214 sp -------------------------------- 127315 a ch 127415 mn 6368 127515 mx 6368 127615 sp -------------------------------- 127716 a aa_ 127816 mn 61610909090909090909090909090909 127916 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 128016 sp -------------------------------- 128117 a cc_ 128217 mn 63630909090909090909090909090909 128317 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 128417 sp -------------------------------- 128518 a ch_ 128618 mn 63680909090909090909090909090909 128718 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 128818 sp -------------------------------- 128919 a aa% 129019 mn 61610909090909090909090909090909 129119 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 129219 sp -------------------------------- 129320 a cc% 129420 mn 63630909090909090909090909090909 129520 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 129620 sp -------------------------------- 129721 a ch% 129821 mn 63680909090909090909090909090909 129921 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 130021 sp -------------------------------- 130122 a aaa 130222 mn 616161 130322 mx 616161 130422 sp -------------------------------- 130523 a ccc 130623 mn 636363 130723 mx 636363 130823 sp -------------------------------- 130924 a cch 131024 mn 636368 131124 mx 636368 131224 sp -------------------------------- 131325 a aaa_ 131425 mn 61610909090909090909090909090909 131525 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 131625 sp -------------------------------- 131726 a ccc_ 131826 mn 63636309090909090909090909090909 131926 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 132026 sp -------------------------------- 132127 a cch_ 132227 mn 63636809090909090909090909090909 132327 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 132427 sp -------------------------------- 132528 a aaa% 132628 mn 61610909090909090909090909090909 132728 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 132828 sp -------------------------------- 132929 a ccc% 133029 mn 63636309090909090909090909090909 133129 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 133229 sp -------------------------------- 133330 a cch% 133430 mn 63636809090909090909090909090909 133530 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 133630 sp -------------------------------- 133731 a aaaaaaaaaaaaaaaaaaaa 133831 mn 61616161 133931 mx 61616161 134031 sp -------------------------------- 134132 a caaaaaaaaaaaaaaaaaaa 134232 mn 63616109090909090909090909090909 134332 mx 636161EFBFBFEFBFBFEFBFBFEFBFBF20 134432 sp -------------------------------- 1345ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; 1346SELECT * FROM v1; 1347id name val 13481 a 13491 mn 13501 mx 13511 sp -------------------------------- 13522 a _ 13532 mn 09090909090909090909090909090909 13542 mx F48FBFBFF48FBFBFF48FBFBFF48FBFBF 13552 sp -------------------------------- 13563 a % 13573 mn 09090909090909090909090909090909 13583 mx F48FBFBFF48FBFBFF48FBFBFF48FBFBF 13593 sp -------------------------------- 13604 a \_ 13614 mn 5F 13624 mx 5F 13634 sp -------------------------------- 13645 a \% 13655 mn 25 13665 mx 25 13675 sp -------------------------------- 13686 a \ 13696 mn 5C 13706 mx 5C 13716 sp -------------------------------- 13727 a a 13737 mn 61 13747 mx 61 13757 sp -------------------------------- 13768 a c 13778 mn 63 13788 mx 63 13798 sp -------------------------------- 13809 a a_ 13819 mn 61090909090909090909090909090909 13829 mx 61F48FBFBFF48FBFBFF48FBFBF202020 13839 sp -------------------------------- 138410 a c_ 138510 mn 63090909090909090909090909090909 138610 mx 63F48FBFBFF48FBFBFF48FBFBF202020 138710 sp -------------------------------- 138811 a a% 138911 mn 61090909090909090909090909090909 139011 mx 61F48FBFBFF48FBFBFF48FBFBF202020 139111 sp -------------------------------- 139212 a c% 139312 mn 63090909090909090909090909090909 139412 mx 63F48FBFBFF48FBFBFF48FBFBF202020 139512 sp -------------------------------- 139613 a aa 139713 mn 6161 139813 mx 6161 139913 sp -------------------------------- 140014 a cc 140114 mn 6363 140214 mx 6363 140314 sp -------------------------------- 140415 a ch 140515 mn 6368 140615 mx 6368 140715 sp -------------------------------- 140816 a aa_ 140916 mn 61610909090909090909090909090909 141016 mx 6161F48FBFBFF48FBFBFF48FBFBF2020 141116 sp -------------------------------- 141217 a cc_ 141317 mn 63630909090909090909090909090909 141417 mx 6363F48FBFBFF48FBFBFF48FBFBF2020 141517 sp -------------------------------- 141618 a ch_ 141718 mn 63680909090909090909090909090909 141818 mx 6368F48FBFBFF48FBFBFF48FBFBF2020 141918 sp -------------------------------- 142019 a aa% 142119 mn 61610909090909090909090909090909 142219 mx 6161F48FBFBFF48FBFBFF48FBFBF2020 142319 sp -------------------------------- 142420 a cc% 142520 mn 63630909090909090909090909090909 142620 mx 6363F48FBFBFF48FBFBFF48FBFBF2020 142720 sp -------------------------------- 142821 a ch% 142921 mn 63680909090909090909090909090909 143021 mx 6368F48FBFBFF48FBFBFF48FBFBF2020 143121 sp -------------------------------- 143222 a aaa 143322 mn 616161 143422 mx 616161 143522 sp -------------------------------- 143623 a ccc 143723 mn 636363 143823 mx 636363 143923 sp -------------------------------- 144024 a cch 144124 mn 636368 144224 mx 636368 144324 sp -------------------------------- 144425 a aaa_ 144525 mn 61616109090909090909090909090909 144625 mx 616161F48FBFBFF48FBFBFF48FBFBF20 144725 sp -------------------------------- 144826 a ccc_ 144926 mn 63636309090909090909090909090909 145026 mx 636363F48FBFBFF48FBFBFF48FBFBF20 145126 sp -------------------------------- 145227 a cch_ 145327 mn 63636809090909090909090909090909 145427 mx 636368F48FBFBFF48FBFBFF48FBFBF20 145527 sp -------------------------------- 145628 a aaa% 145728 mn 61616109090909090909090909090909 145828 mx 616161F48FBFBFF48FBFBFF48FBFBF20 145928 sp -------------------------------- 146029 a ccc% 146129 mn 63636309090909090909090909090909 146229 mx 636363F48FBFBFF48FBFBFF48FBFBF20 146329 sp -------------------------------- 146430 a cch% 146530 mn 63636809090909090909090909090909 146630 mx 636368F48FBFBFF48FBFBFF48FBFBF20 146730 sp -------------------------------- 146831 a aaaaaaaaaaaaaaaaaaaa 146931 mn 61616161 147031 mx 61616161 147131 sp -------------------------------- 147232 a caaaaaaaaaaaaaaaaaaa 147332 mn 63616161 147432 mx 63616161 147532 sp -------------------------------- 1476ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2; 1477SELECT * FROM v1; 1478id name val 14791 a 14801 mn 14811 mx 14821 sp -------------------------------- 14832 a _ 14842 mn 0000 14852 mx FFFF 14862 sp -------------------------------- 14873 a % 14883 mn 00000000000000000000000000000000 14893 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 14903 sp -------------------------------- 14914 a \_ 14924 mn 005F 14934 mx 005F 14944 sp -------------------------------- 14955 a \% 14965 mn 0025 14975 mx 0025 14985 sp -------------------------------- 14996 a \ 15006 mn 005C 15016 mx 005C 15026 sp -------------------------------- 15037 a a 15047 mn 0061 15057 mx 0061 15067 sp -------------------------------- 15078 a c 15088 mn 0063 15098 mx 0063 15108 sp -------------------------------- 15119 a a_ 15129 mn 00610000 15139 mx 0061FFFF 15149 sp -------------------------------- 151510 a c_ 151610 mn 00630000 151710 mx 0063FFFF 151810 sp -------------------------------- 151911 a a% 152011 mn 00610000000000000000000000000000 152111 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 152211 sp -------------------------------- 152312 a c% 152412 mn 00630000000000000000000000000000 152512 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 152612 sp -------------------------------- 152713 a aa 152813 mn 00610061 152913 mx 00610061 153013 sp -------------------------------- 153114 a cc 153214 mn 00630063 153314 mx 00630063 153414 sp -------------------------------- 153515 a ch 153615 mn 00630068 153715 mx 00630068 153815 sp -------------------------------- 153916 a aa_ 154016 mn 006100610000 154116 mx 00610061FFFF 154216 sp -------------------------------- 154317 a cc_ 154417 mn 006300630000 154517 mx 00630063FFFF 154617 sp -------------------------------- 154718 a ch_ 154818 mn 006300680000 154918 mx 00630068FFFF 155018 sp -------------------------------- 155119 a aa% 155219 mn 00610061000000000000000000000000 155319 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 155419 sp -------------------------------- 155520 a cc% 155620 mn 00630063000000000000000000000000 155720 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 155820 sp -------------------------------- 155921 a ch% 156021 mn 00630068000000000000000000000000 156121 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 156221 sp -------------------------------- 156322 a aaa 156422 mn 006100610061 156522 mx 006100610061 156622 sp -------------------------------- 156723 a ccc 156823 mn 006300630063 156923 mx 006300630063 157023 sp -------------------------------- 157124 a cch 157224 mn 006300630068 157324 mx 006300630068 157424 sp -------------------------------- 157525 a aaa_ 157625 mn 0061006100610000 157725 mx 006100610061FFFF 157825 sp -------------------------------- 157926 a ccc_ 158026 mn 0063006300630000 158126 mx 006300630063FFFF 158226 sp -------------------------------- 158327 a cch_ 158427 mn 0063006300680000 158527 mx 006300630068FFFF 158627 sp -------------------------------- 158728 a aaa% 158828 mn 00610061006100000000000000000000 158928 mx 006100610061FFFFFFFFFFFFFFFFFFFF 159028 sp -------------------------------- 159129 a ccc% 159229 mn 00630063006300000000000000000000 159329 mx 006300630063FFFFFFFFFFFFFFFFFFFF 159429 sp -------------------------------- 159530 a cch% 159630 mn 00630063006800000000000000000000 159730 mx 006300630068FFFFFFFFFFFFFFFFFFFF 159830 sp -------------------------------- 159931 a aaaaaaaaaaaaaaaaaaaa 160031 mn 00610061006100610061006100610061 160131 mx 00610061006100610061006100610061 160231 sp -------------------------------- 160332 a caaaaaaaaaaaaaaaaaaa 160432 mn 00630061006100610061006100610061 160532 mx 00630061006100610061006100610061 160632 sp -------------------------------- 1607ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_unicode_ci; 1608SELECT * FROM v1; 1609id name val 16101 a 16111 mn 16121 mx 16131 sp -------------------------------- 16142 a _ 16152 mn 0009 16162 mx FFFF 16172 sp -------------------------------- 16183 a % 16193 mn 00090009000900090009000900090009 16203 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 16213 sp -------------------------------- 16224 a \_ 16234 mn 005F 16244 mx 005F 16254 sp -------------------------------- 16265 a \% 16275 mn 0025 16285 mx 0025 16295 sp -------------------------------- 16306 a \ 16316 mn 005C 16326 mx 005C 16336 sp -------------------------------- 16347 a a 16357 mn 0061 16367 mx 0061 16377 sp -------------------------------- 16388 a c 16398 mn 0063 16408 mx 0063 16418 sp -------------------------------- 16429 a a_ 16439 mn 00610009 16449 mx 0061FFFF 16459 sp -------------------------------- 164610 a c_ 164710 mn 00630009 164810 mx 0063FFFF 164910 sp -------------------------------- 165011 a a% 165111 mn 00610009000900090009000900090009 165211 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 165311 sp -------------------------------- 165412 a c% 165512 mn 00630009000900090009000900090009 165612 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 165712 sp -------------------------------- 165813 a aa 165913 mn 00610061 166013 mx 00610061 166113 sp -------------------------------- 166214 a cc 166314 mn 00630063 166414 mx 00630063 166514 sp -------------------------------- 166615 a ch 166715 mn 00630068 166815 mx 00630068 166915 sp -------------------------------- 167016 a aa_ 167116 mn 006100610009 167216 mx 00610061FFFF 167316 sp -------------------------------- 167417 a cc_ 167517 mn 006300630009 167617 mx 00630063FFFF 167717 sp -------------------------------- 167818 a ch_ 167918 mn 006300680009 168018 mx 00630068FFFF 168118 sp -------------------------------- 168219 a aa% 168319 mn 00610061000900090009000900090009 168419 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 168519 sp -------------------------------- 168620 a cc% 168720 mn 00630063000900090009000900090009 168820 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 168920 sp -------------------------------- 169021 a ch% 169121 mn 00630068000900090009000900090009 169221 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 169321 sp -------------------------------- 169422 a aaa 169522 mn 006100610061 169622 mx 006100610061 169722 sp -------------------------------- 169823 a ccc 169923 mn 006300630063 170023 mx 006300630063 170123 sp -------------------------------- 170224 a cch 170324 mn 006300630068 170424 mx 006300630068 170524 sp -------------------------------- 170625 a aaa_ 170725 mn 0061006100610009 170825 mx 006100610061FFFF 170925 sp -------------------------------- 171026 a ccc_ 171126 mn 0063006300630009 171226 mx 006300630063FFFF 171326 sp -------------------------------- 171427 a cch_ 171527 mn 0063006300680009 171627 mx 006300630068FFFF 171727 sp -------------------------------- 171828 a aaa% 171928 mn 00610061006100090009000900090009 172028 mx 006100610061FFFFFFFFFFFFFFFFFFFF 172128 sp -------------------------------- 172229 a ccc% 172329 mn 00630063006300090009000900090009 172429 mx 006300630063FFFFFFFFFFFFFFFFFFFF 172529 sp -------------------------------- 172630 a cch% 172730 mn 00630063006800090009000900090009 172830 mx 006300630068FFFFFFFFFFFFFFFFFFFF 172930 sp -------------------------------- 173031 a aaaaaaaaaaaaaaaaaaaa 173131 mn 00610061006100610061006100610061 173231 mx 00610061006100610061006100610061 173331 sp -------------------------------- 173432 a caaaaaaaaaaaaaaaaaaa 173532 mn 00630061006100610061006100610061 173632 mx 00630061006100610061006100610061 173732 sp -------------------------------- 1738ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_czech_ci; 1739SELECT * FROM v1; 1740id name val 17411 a 17421 mn 17431 mx 17441 sp -------------------------------- 17452 a _ 17462 mn 0009 17472 mx FFFF 17482 sp -------------------------------- 17493 a % 17503 mn 00090009000900090009000900090009 17513 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 17523 sp -------------------------------- 17534 a \_ 17544 mn 005F 17554 mx 005F 17564 sp -------------------------------- 17575 a \% 17585 mn 0025 17595 mx 0025 17605 sp -------------------------------- 17616 a \ 17626 mn 005C 17636 mx 005C 17646 sp -------------------------------- 17657 a a 17667 mn 0061 17677 mx 0061 17687 sp -------------------------------- 17698 a c 17708 mn 0063 17718 mx 0063 17728 sp -------------------------------- 17739 a a_ 17749 mn 00610009 17759 mx 0061FFFF 17769 sp -------------------------------- 177710 a c_ 177810 mn 00090009000900090009000900090009 177910 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 178010 sp -------------------------------- 178111 a a% 178211 mn 00610009000900090009000900090009 178311 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 178411 sp -------------------------------- 178512 a c% 178612 mn 00090009000900090009000900090009 178712 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 178812 sp -------------------------------- 178913 a aa 179013 mn 00610061 179113 mx 00610061 179213 sp -------------------------------- 179314 a cc 179414 mn 00630063 179514 mx 00630063 179614 sp -------------------------------- 179715 a ch 179815 mn 00630068 179915 mx 00630068 180015 sp -------------------------------- 180116 a aa_ 180216 mn 006100610009 180316 mx 00610061FFFF 180416 sp -------------------------------- 180517 a cc_ 180617 mn 00630009000900090009000900090009 180717 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 180817 sp -------------------------------- 180918 a ch_ 181018 mn 006300680009 181118 mx 00630068FFFF 181218 sp -------------------------------- 181319 a aa% 181419 mn 00610061000900090009000900090009 181519 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 181619 sp -------------------------------- 181720 a cc% 181820 mn 00630009000900090009000900090009 181920 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 182020 sp -------------------------------- 182121 a ch% 182221 mn 00630068000900090009000900090009 182321 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 182421 sp -------------------------------- 182522 a aaa 182622 mn 006100610061 182722 mx 006100610061 182822 sp -------------------------------- 182923 a ccc 183023 mn 006300630063 183123 mx 006300630063 183223 sp -------------------------------- 183324 a cch 183424 mn 006300630068 183524 mx 006300630068 183624 sp -------------------------------- 183725 a aaa_ 183825 mn 0061006100610009 183925 mx 006100610061FFFF 184025 sp -------------------------------- 184126 a ccc_ 184226 mn 00630063000900090009000900090009 184326 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 184426 sp -------------------------------- 184527 a cch_ 184627 mn 0063006300680009 184727 mx 006300630068FFFF 184827 sp -------------------------------- 184928 a aaa% 185028 mn 00610061006100090009000900090009 185128 mx 006100610061FFFFFFFFFFFFFFFFFFFF 185228 sp -------------------------------- 185329 a ccc% 185429 mn 00630063000900090009000900090009 185529 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 185629 sp -------------------------------- 185730 a cch% 185830 mn 00630063006800090009000900090009 185930 mx 006300630068FFFFFFFFFFFFFFFFFFFF 186030 sp -------------------------------- 186131 a aaaaaaaaaaaaaaaaaaaa 186231 mn 00610061006100610061006100610061 186331 mx 00610061006100610061006100610061 186431 sp -------------------------------- 186532 a caaaaaaaaaaaaaaaaaaa 186632 mn 00630061006100610061006100610061 186732 mx 00630061006100610061006100610061 186832 sp -------------------------------- 1869ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_danish_ci; 1870SELECT * FROM v1; 1871id name val 18721 a 18731 mn 18741 mx 18751 sp -------------------------------- 18762 a _ 18772 mn 0009 18782 mx FFFF 18792 sp -------------------------------- 18803 a % 18813 mn 00090009000900090009000900090009 18823 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 18833 sp -------------------------------- 18844 a \_ 18854 mn 005F 18864 mx 005F 18874 sp -------------------------------- 18885 a \% 18895 mn 0025 18905 mx 0025 18915 sp -------------------------------- 18926 a \ 18936 mn 005C 18946 mx 005C 18956 sp -------------------------------- 18967 a a 18977 mn 0061 18987 mx 0061 18997 sp -------------------------------- 19008 a c 19018 mn 0063 19028 mx 0063 19038 sp -------------------------------- 19049 a a_ 19059 mn 00090009000900090009000900090009 19069 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 19079 sp -------------------------------- 190810 a c_ 190910 mn 00630009 191010 mx 0063FFFF 191110 sp -------------------------------- 191211 a a% 191311 mn 00090009000900090009000900090009 191411 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 191511 sp -------------------------------- 191612 a c% 191712 mn 00630009000900090009000900090009 191812 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 191912 sp -------------------------------- 192013 a aa 192113 mn 00610061 192213 mx 00610061 192313 sp -------------------------------- 192414 a cc 192514 mn 00630063 192614 mx 00630063 192714 sp -------------------------------- 192815 a ch 192915 mn 00630068 193015 mx 00630068 193115 sp -------------------------------- 193216 a aa_ 193316 mn 006100610009 193416 mx 00610061FFFF 193516 sp -------------------------------- 193617 a cc_ 193717 mn 006300630009 193817 mx 00630063FFFF 193917 sp -------------------------------- 194018 a ch_ 194118 mn 006300680009 194218 mx 00630068FFFF 194318 sp -------------------------------- 194419 a aa% 194519 mn 00610061000900090009000900090009 194619 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 194719 sp -------------------------------- 194820 a cc% 194920 mn 00630063000900090009000900090009 195020 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 195120 sp -------------------------------- 195221 a ch% 195321 mn 00630068000900090009000900090009 195421 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 195521 sp -------------------------------- 195622 a aaa 195722 mn 006100610061 195822 mx 006100610061 195922 sp -------------------------------- 196023 a ccc 196123 mn 006300630063 196223 mx 006300630063 196323 sp -------------------------------- 196424 a cch 196524 mn 006300630068 196624 mx 006300630068 196724 sp -------------------------------- 196825 a aaa_ 196925 mn 00610061000900090009000900090009 197025 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 197125 sp -------------------------------- 197226 a ccc_ 197326 mn 0063006300630009 197426 mx 006300630063FFFF 197526 sp -------------------------------- 197627 a cch_ 197727 mn 0063006300680009 197827 mx 006300630068FFFF 197927 sp -------------------------------- 198028 a aaa% 198128 mn 00610061000900090009000900090009 198228 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 198328 sp -------------------------------- 198429 a ccc% 198529 mn 00630063006300090009000900090009 198629 mx 006300630063FFFFFFFFFFFFFFFFFFFF 198729 sp -------------------------------- 198830 a cch% 198930 mn 00630063006800090009000900090009 199030 mx 006300630068FFFFFFFFFFFFFFFFFFFF 199130 sp -------------------------------- 199231 a aaaaaaaaaaaaaaaaaaaa 199331 mn 00610061006100610061006100610061 199431 mx 00610061006100610061006100610061 199531 sp -------------------------------- 199632 a caaaaaaaaaaaaaaaaaaa 199732 mn 00630061006100610061006100610009 199832 mx 0063006100610061006100610061FFFF 199932 sp -------------------------------- 2000ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16; 2001SELECT * FROM v1; 2002id name val 20031 a 20041 mn 20051 mx 20061 sp -------------------------------- 20072 a _ 20082 mn 0000 20092 mx FFFF 20102 sp -------------------------------- 20113 a % 20123 mn 00000000000000000000000000000000 20133 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 20143 sp -------------------------------- 20154 a \_ 20164 mn 005F 20174 mx 005F 20184 sp -------------------------------- 20195 a \% 20205 mn 0025 20215 mx 0025 20225 sp -------------------------------- 20236 a \ 20246 mn 005C 20256 mx 005C 20266 sp -------------------------------- 20277 a a 20287 mn 0061 20297 mx 0061 20307 sp -------------------------------- 20318 a c 20328 mn 0063 20338 mx 0063 20348 sp -------------------------------- 20359 a a_ 20369 mn 00610000 20379 mx 0061FFFF 20389 sp -------------------------------- 203910 a c_ 204010 mn 00630000 204110 mx 0063FFFF 204210 sp -------------------------------- 204311 a a% 204411 mn 00610000000000000000000000000000 204511 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 204611 sp -------------------------------- 204712 a c% 204812 mn 00630000000000000000000000000000 204912 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 205012 sp -------------------------------- 205113 a aa 205213 mn 00610061 205313 mx 00610061 205413 sp -------------------------------- 205514 a cc 205614 mn 00630063 205714 mx 00630063 205814 sp -------------------------------- 205915 a ch 206015 mn 00630068 206115 mx 00630068 206215 sp -------------------------------- 206316 a aa_ 206416 mn 006100610000 206516 mx 00610061FFFF 206616 sp -------------------------------- 206717 a cc_ 206817 mn 006300630000 206917 mx 00630063FFFF 207017 sp -------------------------------- 207118 a ch_ 207218 mn 006300680000 207318 mx 00630068FFFF 207418 sp -------------------------------- 207519 a aa% 207619 mn 00610061000000000000000000000000 207719 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 207819 sp -------------------------------- 207920 a cc% 208020 mn 00630063000000000000000000000000 208120 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 208220 sp -------------------------------- 208321 a ch% 208421 mn 00630068000000000000000000000000 208521 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 208621 sp -------------------------------- 208722 a aaa 208822 mn 006100610061 208922 mx 006100610061 209022 sp -------------------------------- 209123 a ccc 209223 mn 006300630063 209323 mx 006300630063 209423 sp -------------------------------- 209524 a cch 209624 mn 006300630068 209724 mx 006300630068 209824 sp -------------------------------- 209925 a aaa_ 210025 mn 0061006100610000 210125 mx 006100610061FFFF 210225 sp -------------------------------- 210326 a ccc_ 210426 mn 0063006300630000 210526 mx 006300630063FFFF 210626 sp -------------------------------- 210727 a cch_ 210827 mn 0063006300680000 210927 mx 006300630068FFFF 211027 sp -------------------------------- 211128 a aaa% 211228 mn 00610061006100000000000000000000 211328 mx 006100610061FFFFFFFFFFFFFFFFFFFF 211428 sp -------------------------------- 211529 a ccc% 211629 mn 00630063006300000000000000000000 211729 mx 006300630063FFFFFFFFFFFFFFFFFFFF 211829 sp -------------------------------- 211930 a cch% 212030 mn 00630063006800000000000000000000 212130 mx 006300630068FFFFFFFFFFFFFFFFFFFF 212230 sp -------------------------------- 212331 a aaaaaaaaaaaaaaaaaaaa 212431 mn 0061006100610061 212531 mx 0061006100610061 212631 sp -------------------------------- 212732 a caaaaaaaaaaaaaaaaaaa 212832 mn 0063006100610061 212932 mx 0063006100610061 213032 sp -------------------------------- 2131ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_unicode_ci; 2132SELECT * FROM v1; 2133id name val 21341 a 21351 mn 21361 mx 21371 sp -------------------------------- 21382 a _ 21392 mn 0009 21402 mx FFFF 21412 sp -------------------------------- 21423 a % 21433 mn 00090009000900090009000900090009 21443 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 21453 sp -------------------------------- 21464 a \_ 21474 mn 005F 21484 mx 005F 21494 sp -------------------------------- 21505 a \% 21515 mn 0025 21525 mx 0025 21535 sp -------------------------------- 21546 a \ 21556 mn 005C 21566 mx 005C 21576 sp -------------------------------- 21587 a a 21597 mn 0061 21607 mx 0061 21617 sp -------------------------------- 21628 a c 21638 mn 0063 21648 mx 0063 21658 sp -------------------------------- 21669 a a_ 21679 mn 00610009 21689 mx 0061FFFF 21699 sp -------------------------------- 217010 a c_ 217110 mn 00630009 217210 mx 0063FFFF 217310 sp -------------------------------- 217411 a a% 217511 mn 00610009000900090009000900090009 217611 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 217711 sp -------------------------------- 217812 a c% 217912 mn 00630009000900090009000900090009 218012 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 218112 sp -------------------------------- 218213 a aa 218313 mn 00610061 218413 mx 00610061 218513 sp -------------------------------- 218614 a cc 218714 mn 00630063 218814 mx 00630063 218914 sp -------------------------------- 219015 a ch 219115 mn 00630068 219215 mx 00630068 219315 sp -------------------------------- 219416 a aa_ 219516 mn 006100610009 219616 mx 00610061FFFF 219716 sp -------------------------------- 219817 a cc_ 219917 mn 006300630009 220017 mx 00630063FFFF 220117 sp -------------------------------- 220218 a ch_ 220318 mn 006300680009 220418 mx 00630068FFFF 220518 sp -------------------------------- 220619 a aa% 220719 mn 00610061000900090009000900090009 220819 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 220919 sp -------------------------------- 221020 a cc% 221120 mn 00630063000900090009000900090009 221220 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 221320 sp -------------------------------- 221421 a ch% 221521 mn 00630068000900090009000900090009 221621 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 221721 sp -------------------------------- 221822 a aaa 221922 mn 006100610061 222022 mx 006100610061 222122 sp -------------------------------- 222223 a ccc 222323 mn 006300630063 222423 mx 006300630063 222523 sp -------------------------------- 222624 a cch 222724 mn 006300630068 222824 mx 006300630068 222924 sp -------------------------------- 223025 a aaa_ 223125 mn 0061006100610009 223225 mx 006100610061FFFF 223325 sp -------------------------------- 223426 a ccc_ 223526 mn 0063006300630009 223626 mx 006300630063FFFF 223726 sp -------------------------------- 223827 a cch_ 223927 mn 0063006300680009 224027 mx 006300630068FFFF 224127 sp -------------------------------- 224228 a aaa% 224328 mn 00610061006100090009000900090009 224428 mx 006100610061FFFFFFFFFFFFFFFFFFFF 224528 sp -------------------------------- 224629 a ccc% 224729 mn 00630063006300090009000900090009 224829 mx 006300630063FFFFFFFFFFFFFFFFFFFF 224929 sp -------------------------------- 225030 a cch% 225130 mn 00630063006800090009000900090009 225230 mx 006300630068FFFFFFFFFFFFFFFFFFFF 225330 sp -------------------------------- 225431 a aaaaaaaaaaaaaaaaaaaa 225531 mn 0061006100610061 225631 mx 0061006100610061 225731 sp -------------------------------- 225832 a caaaaaaaaaaaaaaaaaaa 225932 mn 0063006100610061 226032 mx 0063006100610061 226132 sp -------------------------------- 2262ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_czech_ci; 2263SELECT * FROM v1; 2264id name val 22651 a 22661 mn 22671 mx 22681 sp -------------------------------- 22692 a _ 22702 mn 0009 22712 mx FFFF 22722 sp -------------------------------- 22733 a % 22743 mn 00090009000900090009000900090009 22753 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 22763 sp -------------------------------- 22774 a \_ 22784 mn 005F 22794 mx 005F 22804 sp -------------------------------- 22815 a \% 22825 mn 0025 22835 mx 0025 22845 sp -------------------------------- 22856 a \ 22866 mn 005C 22876 mx 005C 22886 sp -------------------------------- 22897 a a 22907 mn 0061 22917 mx 0061 22927 sp -------------------------------- 22938 a c 22948 mn 0063 22958 mx 0063 22968 sp -------------------------------- 22979 a a_ 22989 mn 00610009 22999 mx 0061FFFF 23009 sp -------------------------------- 230110 a c_ 230210 mn 00090009000900090009000900090009 230310 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 230410 sp -------------------------------- 230511 a a% 230611 mn 00610009000900090009000900090009 230711 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 230811 sp -------------------------------- 230912 a c% 231012 mn 00090009000900090009000900090009 231112 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 231212 sp -------------------------------- 231313 a aa 231413 mn 00610061 231513 mx 00610061 231613 sp -------------------------------- 231714 a cc 231814 mn 00630063 231914 mx 00630063 232014 sp -------------------------------- 232115 a ch 232215 mn 00630068 232315 mx 00630068 232415 sp -------------------------------- 232516 a aa_ 232616 mn 006100610009 232716 mx 00610061FFFF 232816 sp -------------------------------- 232917 a cc_ 233017 mn 00630009000900090009000900090009 233117 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 233217 sp -------------------------------- 233318 a ch_ 233418 mn 006300680009 233518 mx 00630068FFFF 233618 sp -------------------------------- 233719 a aa% 233819 mn 00610061000900090009000900090009 233919 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 234019 sp -------------------------------- 234120 a cc% 234220 mn 00630009000900090009000900090009 234320 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 234420 sp -------------------------------- 234521 a ch% 234621 mn 00630068000900090009000900090009 234721 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 234821 sp -------------------------------- 234922 a aaa 235022 mn 006100610061 235122 mx 006100610061 235222 sp -------------------------------- 235323 a ccc 235423 mn 006300630063 235523 mx 006300630063 235623 sp -------------------------------- 235724 a cch 235824 mn 006300630068 235924 mx 006300630068 236024 sp -------------------------------- 236125 a aaa_ 236225 mn 0061006100610009 236325 mx 006100610061FFFF 236425 sp -------------------------------- 236526 a ccc_ 236626 mn 00630063000900090009000900090009 236726 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 236826 sp -------------------------------- 236927 a cch_ 237027 mn 0063006300680009 237127 mx 006300630068FFFF 237227 sp -------------------------------- 237328 a aaa% 237428 mn 00610061006100090009000900090009 237528 mx 006100610061FFFFFFFFFFFFFFFFFFFF 237628 sp -------------------------------- 237729 a ccc% 237829 mn 00630063000900090009000900090009 237929 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 238029 sp -------------------------------- 238130 a cch% 238230 mn 00630063006800090009000900090009 238330 mx 006300630068FFFFFFFFFFFFFFFFFFFF 238430 sp -------------------------------- 238531 a aaaaaaaaaaaaaaaaaaaa 238631 mn 0061006100610061 238731 mx 0061006100610061 238831 sp -------------------------------- 238932 a caaaaaaaaaaaaaaaaaaa 239032 mn 0063006100610061 239132 mx 0063006100610061 239232 sp -------------------------------- 2393ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_danish_ci; 2394SELECT * FROM v1; 2395id name val 23961 a 23971 mn 23981 mx 23991 sp -------------------------------- 24002 a _ 24012 mn 0009 24022 mx FFFF 24032 sp -------------------------------- 24043 a % 24053 mn 00090009000900090009000900090009 24063 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 24073 sp -------------------------------- 24084 a \_ 24094 mn 005F 24104 mx 005F 24114 sp -------------------------------- 24125 a \% 24135 mn 0025 24145 mx 0025 24155 sp -------------------------------- 24166 a \ 24176 mn 005C 24186 mx 005C 24196 sp -------------------------------- 24207 a a 24217 mn 0061 24227 mx 0061 24237 sp -------------------------------- 24248 a c 24258 mn 0063 24268 mx 0063 24278 sp -------------------------------- 24289 a a_ 24299 mn 00090009000900090009000900090009 24309 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 24319 sp -------------------------------- 243210 a c_ 243310 mn 00630009 243410 mx 0063FFFF 243510 sp -------------------------------- 243611 a a% 243711 mn 00090009000900090009000900090009 243811 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 243911 sp -------------------------------- 244012 a c% 244112 mn 00630009000900090009000900090009 244212 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 244312 sp -------------------------------- 244413 a aa 244513 mn 00610061 244613 mx 00610061 244713 sp -------------------------------- 244814 a cc 244914 mn 00630063 245014 mx 00630063 245114 sp -------------------------------- 245215 a ch 245315 mn 00630068 245415 mx 00630068 245515 sp -------------------------------- 245616 a aa_ 245716 mn 006100610009 245816 mx 00610061FFFF 245916 sp -------------------------------- 246017 a cc_ 246117 mn 006300630009 246217 mx 00630063FFFF 246317 sp -------------------------------- 246418 a ch_ 246518 mn 006300680009 246618 mx 00630068FFFF 246718 sp -------------------------------- 246819 a aa% 246919 mn 00610061000900090009000900090009 247019 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 247119 sp -------------------------------- 247220 a cc% 247320 mn 00630063000900090009000900090009 247420 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 247520 sp -------------------------------- 247621 a ch% 247721 mn 00630068000900090009000900090009 247821 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 247921 sp -------------------------------- 248022 a aaa 248122 mn 006100610061 248222 mx 006100610061 248322 sp -------------------------------- 248423 a ccc 248523 mn 006300630063 248623 mx 006300630063 248723 sp -------------------------------- 248824 a cch 248924 mn 006300630068 249024 mx 006300630068 249124 sp -------------------------------- 249225 a aaa_ 249325 mn 00610061000900090009000900090009 249425 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 249525 sp -------------------------------- 249626 a ccc_ 249726 mn 0063006300630009 249826 mx 006300630063FFFF 249926 sp -------------------------------- 250027 a cch_ 250127 mn 0063006300680009 250227 mx 006300630068FFFF 250327 sp -------------------------------- 250428 a aaa% 250528 mn 00610061000900090009000900090009 250628 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 250728 sp -------------------------------- 250829 a ccc% 250929 mn 00630063006300090009000900090009 251029 mx 006300630063FFFFFFFFFFFFFFFFFFFF 251129 sp -------------------------------- 251230 a cch% 251330 mn 00630063006800090009000900090009 251430 mx 006300630068FFFFFFFFFFFFFFFFFFFF 251530 sp -------------------------------- 251631 a aaaaaaaaaaaaaaaaaaaa 251731 mn 0061006100610061 251831 mx 0061006100610061 251931 sp -------------------------------- 252032 a caaaaaaaaaaaaaaaaaaa 252132 mn 00630061006100090009000900090009 252232 mx 006300610061FFFFFFFFFFFFFFFFFFFF 252332 sp -------------------------------- 2524ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_unicode_520_ci; 2525SELECT * FROM v1; 2526id name val 25271 a 25281 mn 25291 mx 25301 sp -------------------------------- 25312 a _ 25322 mn 0009 25332 mx DBFFDFFF 25342 sp -------------------------------- 25353 a % 25363 mn 00090009000900090009000900090009 25373 mx DBFFDFFFDBFFDFFFDBFFDFFFDBFFDFFF 25383 sp -------------------------------- 25394 a \_ 25404 mn 005F 25414 mx 005F 25424 sp -------------------------------- 25435 a \% 25445 mn 0025 25455 mx 0025 25465 sp -------------------------------- 25476 a \ 25486 mn 005C 25496 mx 005C 25506 sp -------------------------------- 25517 a a 25527 mn 0061 25537 mx 0061 25547 sp -------------------------------- 25558 a c 25568 mn 0063 25578 mx 0063 25588 sp -------------------------------- 25599 a a_ 25609 mn 00610009 25619 mx 0061DBFFDFFF 25629 sp -------------------------------- 256310 a c_ 256410 mn 00630009 256510 mx 0063DBFFDFFF 256610 sp -------------------------------- 256711 a a% 256811 mn 00610009000900090009000900090009 256911 mx 0061DBFFDFFFDBFFDFFFDBFFDFFF0000 257011 sp -------------------------------- 257112 a c% 257212 mn 00630009000900090009000900090009 257312 mx 0063DBFFDFFFDBFFDFFFDBFFDFFF0000 257412 sp -------------------------------- 257513 a aa 257613 mn 00610061 257713 mx 00610061 257813 sp -------------------------------- 257914 a cc 258014 mn 00630063 258114 mx 00630063 258214 sp -------------------------------- 258315 a ch 258415 mn 00630068 258515 mx 00630068 258615 sp -------------------------------- 258716 a aa_ 258816 mn 006100610009 258916 mx 00610061DBFFDFFF 259016 sp -------------------------------- 259117 a cc_ 259217 mn 006300630009 259317 mx 00630063DBFFDFFF 259417 sp -------------------------------- 259518 a ch_ 259618 mn 006300680009 259718 mx 00630068DBFFDFFF 259818 sp -------------------------------- 259919 a aa% 260019 mn 00610061000900090009000900090009 260119 mx 00610061DBFFDFFFDBFFDFFFDBFFDFFF 260219 sp -------------------------------- 260320 a cc% 260420 mn 00630063000900090009000900090009 260520 mx 00630063DBFFDFFFDBFFDFFFDBFFDFFF 260620 sp -------------------------------- 260721 a ch% 260821 mn 00630068000900090009000900090009 260921 mx 00630068DBFFDFFFDBFFDFFFDBFFDFFF 261021 sp -------------------------------- 261122 a aaa 261222 mn 006100610061 261322 mx 006100610061 261422 sp -------------------------------- 261523 a ccc 261623 mn 006300630063 261723 mx 006300630063 261823 sp -------------------------------- 261924 a cch 262024 mn 006300630068 262124 mx 006300630068 262224 sp -------------------------------- 262325 a aaa_ 262425 mn 0061006100610009 262525 mx 006100610061DBFFDFFF 262625 sp -------------------------------- 262726 a ccc_ 262826 mn 0063006300630009 262926 mx 006300630063DBFFDFFF 263026 sp -------------------------------- 263127 a cch_ 263227 mn 0063006300680009 263327 mx 006300630068DBFFDFFF 263427 sp -------------------------------- 263528 a aaa% 263628 mn 00610061006100090009000900090009 263728 mx 006100610061DBFFDFFFDBFFDFFF0000 263828 sp -------------------------------- 263929 a ccc% 264029 mn 00630063006300090009000900090009 264129 mx 006300630063DBFFDFFFDBFFDFFF0000 264229 sp -------------------------------- 264330 a cch% 264430 mn 00630063006800090009000900090009 264530 mx 006300630068DBFFDFFFDBFFDFFF0000 264630 sp -------------------------------- 264731 a aaaaaaaaaaaaaaaaaaaa 264831 mn 0061006100610061 264931 mx 0061006100610061 265031 sp -------------------------------- 265132 a caaaaaaaaaaaaaaaaaaa 265232 mn 0063006100610061 265332 mx 0063006100610061 265432 sp -------------------------------- 2655ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32; 2656SELECT * FROM v1; 2657id name val 26581 a 26591 mn 26601 mx 26611 sp -------------------------------- 26622 a _ 26632 mn 00000000 26642 mx 0000FFFF 26652 sp -------------------------------- 26663 a % 26673 mn 00000000000000000000000000000000 26683 mx 0000FFFF0000FFFF0000FFFF0000FFFF 26693 sp -------------------------------- 26704 a \_ 26714 mn 0000005F 26724 mx 0000005F 26734 sp -------------------------------- 26745 a \% 26755 mn 00000025 26765 mx 00000025 26775 sp -------------------------------- 26786 a \ 26796 mn 0000005C 26806 mx 0000005C 26816 sp -------------------------------- 26827 a a 26837 mn 00000061 26847 mx 00000061 26857 sp -------------------------------- 26868 a c 26878 mn 00000063 26888 mx 00000063 26898 sp -------------------------------- 26909 a a_ 26919 mn 0000006100000000 26929 mx 000000610000FFFF 26939 sp -------------------------------- 269410 a c_ 269510 mn 0000006300000000 269610 mx 000000630000FFFF 269710 sp -------------------------------- 269811 a a% 269911 mn 00000061000000000000000000000000 270011 mx 000000610000FFFF0000FFFF0000FFFF 270111 sp -------------------------------- 270212 a c% 270312 mn 00000063000000000000000000000000 270412 mx 000000630000FFFF0000FFFF0000FFFF 270512 sp -------------------------------- 270613 a aa 270713 mn 0000006100000061 270813 mx 0000006100000061 270913 sp -------------------------------- 271014 a cc 271114 mn 0000006300000063 271214 mx 0000006300000063 271314 sp -------------------------------- 271415 a ch 271515 mn 0000006300000068 271615 mx 0000006300000068 271715 sp -------------------------------- 271816 a aa_ 271916 mn 000000610000006100000000 272016 mx 00000061000000610000FFFF 272116 sp -------------------------------- 272217 a cc_ 272317 mn 000000630000006300000000 272417 mx 00000063000000630000FFFF 272517 sp -------------------------------- 272618 a ch_ 272718 mn 000000630000006800000000 272818 mx 00000063000000680000FFFF 272918 sp -------------------------------- 273019 a aa% 273119 mn 00000061000000610000000000000000 273219 mx 00000061000000610000FFFF0000FFFF 273319 sp -------------------------------- 273420 a cc% 273520 mn 00000063000000630000000000000000 273620 mx 00000063000000630000FFFF0000FFFF 273720 sp -------------------------------- 273821 a ch% 273921 mn 00000063000000680000000000000000 274021 mx 00000063000000680000FFFF0000FFFF 274121 sp -------------------------------- 274222 a aaa 274322 mn 000000610000006100000061 274422 mx 000000610000006100000061 274522 sp -------------------------------- 274623 a ccc 274723 mn 000000630000006300000063 274823 mx 000000630000006300000063 274923 sp -------------------------------- 275024 a cch 275124 mn 000000630000006300000068 275224 mx 000000630000006300000068 275324 sp -------------------------------- 275425 a aaa_ 275525 mn 00000061000000610000006100000000 275625 mx 0000006100000061000000610000FFFF 275725 sp -------------------------------- 275826 a ccc_ 275926 mn 00000063000000630000006300000000 276026 mx 0000006300000063000000630000FFFF 276126 sp -------------------------------- 276227 a cch_ 276327 mn 00000063000000630000006800000000 276427 mx 0000006300000063000000680000FFFF 276527 sp -------------------------------- 276628 a aaa% 276728 mn 00000061000000610000006100000000 276828 mx 0000006100000061000000610000FFFF 276928 sp -------------------------------- 277029 a ccc% 277129 mn 00000063000000630000006300000000 277229 mx 0000006300000063000000630000FFFF 277329 sp -------------------------------- 277430 a cch% 277530 mn 00000063000000630000006800000000 277630 mx 0000006300000063000000680000FFFF 277730 sp -------------------------------- 277831 a aaaaaaaaaaaaaaaaaaaa 277931 mn 00000061000000610000006100000061 278031 mx 00000061000000610000006100000061 278131 sp -------------------------------- 278232 a caaaaaaaaaaaaaaaaaaa 278332 mn 00000063000000610000006100000061 278432 mx 00000063000000610000006100000061 278532 sp -------------------------------- 2786ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_unicode_ci; 2787SELECT * FROM v1; 2788id name val 27891 a 27901 mn 27911 mx 27921 sp -------------------------------- 27932 a _ 27942 mn 00000009 27952 mx 0000FFFF 27962 sp -------------------------------- 27973 a % 27983 mn 00000009000000090000000900000009 27993 mx 0000FFFF0000FFFF0000FFFF0000FFFF 28003 sp -------------------------------- 28014 a \_ 28024 mn 0000005F 28034 mx 0000005F 28044 sp -------------------------------- 28055 a \% 28065 mn 00000025 28075 mx 00000025 28085 sp -------------------------------- 28096 a \ 28106 mn 0000005C 28116 mx 0000005C 28126 sp -------------------------------- 28137 a a 28147 mn 00000061 28157 mx 00000061 28167 sp -------------------------------- 28178 a c 28188 mn 00000063 28198 mx 00000063 28208 sp -------------------------------- 28219 a a_ 28229 mn 0000006100000009 28239 mx 000000610000FFFF 28249 sp -------------------------------- 282510 a c_ 282610 mn 0000006300000009 282710 mx 000000630000FFFF 282810 sp -------------------------------- 282911 a a% 283011 mn 00000061000000090000000900000009 283111 mx 000000610000FFFF0000FFFF0000FFFF 283211 sp -------------------------------- 283312 a c% 283412 mn 00000063000000090000000900000009 283512 mx 000000630000FFFF0000FFFF0000FFFF 283612 sp -------------------------------- 283713 a aa 283813 mn 0000006100000061 283913 mx 0000006100000061 284013 sp -------------------------------- 284114 a cc 284214 mn 0000006300000063 284314 mx 0000006300000063 284414 sp -------------------------------- 284515 a ch 284615 mn 0000006300000068 284715 mx 0000006300000068 284815 sp -------------------------------- 284916 a aa_ 285016 mn 000000610000006100000009 285116 mx 00000061000000610000FFFF 285216 sp -------------------------------- 285317 a cc_ 285417 mn 000000630000006300000009 285517 mx 00000063000000630000FFFF 285617 sp -------------------------------- 285718 a ch_ 285818 mn 000000630000006800000009 285918 mx 00000063000000680000FFFF 286018 sp -------------------------------- 286119 a aa% 286219 mn 00000061000000610000000900000009 286319 mx 00000061000000610000FFFF0000FFFF 286419 sp -------------------------------- 286520 a cc% 286620 mn 00000063000000630000000900000009 286720 mx 00000063000000630000FFFF0000FFFF 286820 sp -------------------------------- 286921 a ch% 287021 mn 00000063000000680000000900000009 287121 mx 00000063000000680000FFFF0000FFFF 287221 sp -------------------------------- 287322 a aaa 287422 mn 000000610000006100000061 287522 mx 000000610000006100000061 287622 sp -------------------------------- 287723 a ccc 287823 mn 000000630000006300000063 287923 mx 000000630000006300000063 288023 sp -------------------------------- 288124 a cch 288224 mn 000000630000006300000068 288324 mx 000000630000006300000068 288424 sp -------------------------------- 288525 a aaa_ 288625 mn 00000061000000610000006100000009 288725 mx 0000006100000061000000610000FFFF 288825 sp -------------------------------- 288926 a ccc_ 289026 mn 00000063000000630000006300000009 289126 mx 0000006300000063000000630000FFFF 289226 sp -------------------------------- 289327 a cch_ 289427 mn 00000063000000630000006800000009 289527 mx 0000006300000063000000680000FFFF 289627 sp -------------------------------- 289728 a aaa% 289828 mn 00000061000000610000006100000009 289928 mx 0000006100000061000000610000FFFF 290028 sp -------------------------------- 290129 a ccc% 290229 mn 00000063000000630000006300000009 290329 mx 0000006300000063000000630000FFFF 290429 sp -------------------------------- 290530 a cch% 290630 mn 00000063000000630000006800000009 290730 mx 0000006300000063000000680000FFFF 290830 sp -------------------------------- 290931 a aaaaaaaaaaaaaaaaaaaa 291031 mn 00000061000000610000006100000061 291131 mx 00000061000000610000006100000061 291231 sp -------------------------------- 291332 a caaaaaaaaaaaaaaaaaaa 291432 mn 00000063000000610000006100000061 291532 mx 00000063000000610000006100000061 291632 sp -------------------------------- 2917ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_czech_ci; 2918SELECT * FROM v1; 2919id name val 29201 a 29211 mn 29221 mx 29231 sp -------------------------------- 29242 a _ 29252 mn 00000009 29262 mx 0000FFFF 29272 sp -------------------------------- 29283 a % 29293 mn 00000009000000090000000900000009 29303 mx 0000FFFF0000FFFF0000FFFF0000FFFF 29313 sp -------------------------------- 29324 a \_ 29334 mn 0000005F 29344 mx 0000005F 29354 sp -------------------------------- 29365 a \% 29375 mn 00000025 29385 mx 00000025 29395 sp -------------------------------- 29406 a \ 29416 mn 0000005C 29426 mx 0000005C 29436 sp -------------------------------- 29447 a a 29457 mn 00000061 29467 mx 00000061 29477 sp -------------------------------- 29488 a c 29498 mn 00000063 29508 mx 00000063 29518 sp -------------------------------- 29529 a a_ 29539 mn 0000006100000009 29549 mx 000000610000FFFF 29559 sp -------------------------------- 295610 a c_ 295710 mn 00000009000000090000000900000009 295810 mx 0000FFFF0000FFFF0000FFFF0000FFFF 295910 sp -------------------------------- 296011 a a% 296111 mn 00000061000000090000000900000009 296211 mx 000000610000FFFF0000FFFF0000FFFF 296311 sp -------------------------------- 296412 a c% 296512 mn 00000009000000090000000900000009 296612 mx 0000FFFF0000FFFF0000FFFF0000FFFF 296712 sp -------------------------------- 296813 a aa 296913 mn 0000006100000061 297013 mx 0000006100000061 297113 sp -------------------------------- 297214 a cc 297314 mn 0000006300000063 297414 mx 0000006300000063 297514 sp -------------------------------- 297615 a ch 297715 mn 0000006300000068 297815 mx 0000006300000068 297915 sp -------------------------------- 298016 a aa_ 298116 mn 000000610000006100000009 298216 mx 00000061000000610000FFFF 298316 sp -------------------------------- 298417 a cc_ 298517 mn 00000063000000090000000900000009 298617 mx 000000630000FFFF0000FFFF0000FFFF 298717 sp -------------------------------- 298818 a ch_ 298918 mn 000000630000006800000009 299018 mx 00000063000000680000FFFF 299118 sp -------------------------------- 299219 a aa% 299319 mn 00000061000000610000000900000009 299419 mx 00000061000000610000FFFF0000FFFF 299519 sp -------------------------------- 299620 a cc% 299720 mn 00000063000000090000000900000009 299820 mx 000000630000FFFF0000FFFF0000FFFF 299920 sp -------------------------------- 300021 a ch% 300121 mn 00000063000000680000000900000009 300221 mx 00000063000000680000FFFF0000FFFF 300321 sp -------------------------------- 300422 a aaa 300522 mn 000000610000006100000061 300622 mx 000000610000006100000061 300722 sp -------------------------------- 300823 a ccc 300923 mn 000000630000006300000063 301023 mx 000000630000006300000063 301123 sp -------------------------------- 301224 a cch 301324 mn 000000630000006300000068 301424 mx 000000630000006300000068 301524 sp -------------------------------- 301625 a aaa_ 301725 mn 00000061000000610000006100000009 301825 mx 0000006100000061000000610000FFFF 301925 sp -------------------------------- 302026 a ccc_ 302126 mn 00000063000000630000000900000009 302226 mx 00000063000000630000FFFF0000FFFF 302326 sp -------------------------------- 302427 a cch_ 302527 mn 00000063000000630000006800000009 302627 mx 0000006300000063000000680000FFFF 302727 sp -------------------------------- 302828 a aaa% 302928 mn 00000061000000610000006100000009 303028 mx 0000006100000061000000610000FFFF 303128 sp -------------------------------- 303229 a ccc% 303329 mn 00000063000000630000000900000009 303429 mx 00000063000000630000FFFF0000FFFF 303529 sp -------------------------------- 303630 a cch% 303730 mn 00000063000000630000006800000009 303830 mx 0000006300000063000000680000FFFF 303930 sp -------------------------------- 304031 a aaaaaaaaaaaaaaaaaaaa 304131 mn 00000061000000610000006100000061 304231 mx 00000061000000610000006100000061 304331 sp -------------------------------- 304432 a caaaaaaaaaaaaaaaaaaa 304532 mn 00000063000000610000006100000061 304632 mx 00000063000000610000006100000061 304732 sp -------------------------------- 3048ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_danish_ci; 3049SELECT * FROM v1; 3050id name val 30511 a 30521 mn 30531 mx 30541 sp -------------------------------- 30552 a _ 30562 mn 00000009 30572 mx 0000FFFF 30582 sp -------------------------------- 30593 a % 30603 mn 00000009000000090000000900000009 30613 mx 0000FFFF0000FFFF0000FFFF0000FFFF 30623 sp -------------------------------- 30634 a \_ 30644 mn 0000005F 30654 mx 0000005F 30664 sp -------------------------------- 30675 a \% 30685 mn 00000025 30695 mx 00000025 30705 sp -------------------------------- 30716 a \ 30726 mn 0000005C 30736 mx 0000005C 30746 sp -------------------------------- 30757 a a 30767 mn 00000061 30777 mx 00000061 30787 sp -------------------------------- 30798 a c 30808 mn 00000063 30818 mx 00000063 30828 sp -------------------------------- 30839 a a_ 30849 mn 00000009000000090000000900000009 30859 mx 0000FFFF0000FFFF0000FFFF0000FFFF 30869 sp -------------------------------- 308710 a c_ 308810 mn 0000006300000009 308910 mx 000000630000FFFF 309010 sp -------------------------------- 309111 a a% 309211 mn 00000009000000090000000900000009 309311 mx 0000FFFF0000FFFF0000FFFF0000FFFF 309411 sp -------------------------------- 309512 a c% 309612 mn 00000063000000090000000900000009 309712 mx 000000630000FFFF0000FFFF0000FFFF 309812 sp -------------------------------- 309913 a aa 310013 mn 0000006100000061 310113 mx 0000006100000061 310213 sp -------------------------------- 310314 a cc 310414 mn 0000006300000063 310514 mx 0000006300000063 310614 sp -------------------------------- 310715 a ch 310815 mn 0000006300000068 310915 mx 0000006300000068 311015 sp -------------------------------- 311116 a aa_ 311216 mn 000000610000006100000009 311316 mx 00000061000000610000FFFF 311416 sp -------------------------------- 311517 a cc_ 311617 mn 000000630000006300000009 311717 mx 00000063000000630000FFFF 311817 sp -------------------------------- 311918 a ch_ 312018 mn 000000630000006800000009 312118 mx 00000063000000680000FFFF 312218 sp -------------------------------- 312319 a aa% 312419 mn 00000061000000610000000900000009 312519 mx 00000061000000610000FFFF0000FFFF 312619 sp -------------------------------- 312720 a cc% 312820 mn 00000063000000630000000900000009 312920 mx 00000063000000630000FFFF0000FFFF 313020 sp -------------------------------- 313121 a ch% 313221 mn 00000063000000680000000900000009 313321 mx 00000063000000680000FFFF0000FFFF 313421 sp -------------------------------- 313522 a aaa 313622 mn 000000610000006100000061 313722 mx 000000610000006100000061 313822 sp -------------------------------- 313923 a ccc 314023 mn 000000630000006300000063 314123 mx 000000630000006300000063 314223 sp -------------------------------- 314324 a cch 314424 mn 000000630000006300000068 314524 mx 000000630000006300000068 314624 sp -------------------------------- 314725 a aaa_ 314825 mn 00000061000000610000000900000009 314925 mx 00000061000000610000FFFF0000FFFF 315025 sp -------------------------------- 315126 a ccc_ 315226 mn 00000063000000630000006300000009 315326 mx 0000006300000063000000630000FFFF 315426 sp -------------------------------- 315527 a cch_ 315627 mn 00000063000000630000006800000009 315727 mx 0000006300000063000000680000FFFF 315827 sp -------------------------------- 315928 a aaa% 316028 mn 00000061000000610000000900000009 316128 mx 00000061000000610000FFFF0000FFFF 316228 sp -------------------------------- 316329 a ccc% 316429 mn 00000063000000630000006300000009 316529 mx 0000006300000063000000630000FFFF 316629 sp -------------------------------- 316730 a cch% 316830 mn 00000063000000630000006800000009 316930 mx 0000006300000063000000680000FFFF 317030 sp -------------------------------- 317131 a aaaaaaaaaaaaaaaaaaaa 317231 mn 00000061000000610000006100000061 317331 mx 00000061000000610000006100000061 317431 sp -------------------------------- 317532 a caaaaaaaaaaaaaaaaaaa 317632 mn 00000063000000610000006100000009 317732 mx 0000006300000061000000610000FFFF 317832 sp -------------------------------- 3179ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_unicode_520_ci; 3180SELECT * FROM v1; 3181id name val 31821 a 31831 mn 31841 mx 31851 sp -------------------------------- 31862 a _ 31872 mn 00000009 31882 mx 0010FFFF 31892 sp -------------------------------- 31903 a % 31913 mn 00000009000000090000000900000009 31923 mx 0010FFFF0010FFFF0010FFFF0010FFFF 31933 sp -------------------------------- 31944 a \_ 31954 mn 0000005F 31964 mx 0000005F 31974 sp -------------------------------- 31985 a \% 31995 mn 00000025 32005 mx 00000025 32015 sp -------------------------------- 32026 a \ 32036 mn 0000005C 32046 mx 0000005C 32056 sp -------------------------------- 32067 a a 32077 mn 00000061 32087 mx 00000061 32097 sp -------------------------------- 32108 a c 32118 mn 00000063 32128 mx 00000063 32138 sp -------------------------------- 32149 a a_ 32159 mn 0000006100000009 32169 mx 000000610010FFFF 32179 sp -------------------------------- 321810 a c_ 321910 mn 0000006300000009 322010 mx 000000630010FFFF 322110 sp -------------------------------- 322211 a a% 322311 mn 00000061000000090000000900000009 322411 mx 000000610010FFFF0010FFFF0010FFFF 322511 sp -------------------------------- 322612 a c% 322712 mn 00000063000000090000000900000009 322812 mx 000000630010FFFF0010FFFF0010FFFF 322912 sp -------------------------------- 323013 a aa 323113 mn 0000006100000061 323213 mx 0000006100000061 323313 sp -------------------------------- 323414 a cc 323514 mn 0000006300000063 323614 mx 0000006300000063 323714 sp -------------------------------- 323815 a ch 323915 mn 0000006300000068 324015 mx 0000006300000068 324115 sp -------------------------------- 324216 a aa_ 324316 mn 000000610000006100000009 324416 mx 00000061000000610010FFFF 324516 sp -------------------------------- 324617 a cc_ 324717 mn 000000630000006300000009 324817 mx 00000063000000630010FFFF 324917 sp -------------------------------- 325018 a ch_ 325118 mn 000000630000006800000009 325218 mx 00000063000000680010FFFF 325318 sp -------------------------------- 325419 a aa% 325519 mn 00000061000000610000000900000009 325619 mx 00000061000000610010FFFF0010FFFF 325719 sp -------------------------------- 325820 a cc% 325920 mn 00000063000000630000000900000009 326020 mx 00000063000000630010FFFF0010FFFF 326120 sp -------------------------------- 326221 a ch% 326321 mn 00000063000000680000000900000009 326421 mx 00000063000000680010FFFF0010FFFF 326521 sp -------------------------------- 326622 a aaa 326722 mn 000000610000006100000061 326822 mx 000000610000006100000061 326922 sp -------------------------------- 327023 a ccc 327123 mn 000000630000006300000063 327223 mx 000000630000006300000063 327323 sp -------------------------------- 327424 a cch 327524 mn 000000630000006300000068 327624 mx 000000630000006300000068 327724 sp -------------------------------- 327825 a aaa_ 327925 mn 00000061000000610000006100000009 328025 mx 0000006100000061000000610010FFFF 328125 sp -------------------------------- 328226 a ccc_ 328326 mn 00000063000000630000006300000009 328426 mx 0000006300000063000000630010FFFF 328526 sp -------------------------------- 328627 a cch_ 328727 mn 00000063000000630000006800000009 328827 mx 0000006300000063000000680010FFFF 328927 sp -------------------------------- 329028 a aaa% 329128 mn 00000061000000610000006100000009 329228 mx 0000006100000061000000610010FFFF 329328 sp -------------------------------- 329429 a ccc% 329529 mn 00000063000000630000006300000009 329629 mx 0000006300000063000000630010FFFF 329729 sp -------------------------------- 329830 a cch% 329930 mn 00000063000000630000006800000009 330030 mx 0000006300000063000000680010FFFF 330130 sp -------------------------------- 330231 a aaaaaaaaaaaaaaaaaaaa 330331 mn 00000061000000610000006100000061 330431 mx 00000061000000610000006100000061 330531 sp -------------------------------- 330632 a caaaaaaaaaaaaaaaaaaa 330732 mn 00000063000000610000006100000061 330832 mx 00000063000000610000006100000061 330932 sp -------------------------------- 3310DROP VIEW v1; 3311DROP TABLE t1; 3312