1SET NAMES utf8; 2DROP TABLE IF EXISTS t1; 3DROP VIEW IF EXISTS v1; 4CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a VARBINARY(32)); 5INSERT INTO t1 (a) VALUES (''),('_'),('%'),('\_'),('\%'),('\\'); 6INSERT INTO t1 (a) VALUES ('a'),('c'); 7INSERT INTO t1 (a) VALUES ('a_'),('c_'); 8INSERT INTO t1 (a) VALUES ('a%'),('c%'); 9INSERT INTO t1 (a) VALUES ('aa'),('cc'),('ch'); 10INSERT INTO t1 (a) VALUES ('aa_'),('cc_'),('ch_'); 11INSERT INTO t1 (a) VALUES ('aa%'),('cc%'),('ch%'); 12INSERT INTO t1 (a) VALUES ('aaa'),('ccc'),('cch'); 13INSERT INTO t1 (a) VALUES ('aaa_'),('ccc_'),('cch_'); 14INSERT INTO t1 (a) VALUES ('aaa%'),('ccc%'),('cch%'); 15INSERT INTO t1 (a) VALUES ('aaaaaaaaaaaaaaaaaaaa'); 16INSERT INTO t1 (a) VALUES ('caaaaaaaaaaaaaaaaaaa'); 17CREATE VIEW v1 AS 18SELECT id, 'a' AS name, a AS val FROM t1 19UNION 20SELECT id, 'mn', HEX(LIKE_RANGE_MIN(a, 16)) AS min FROM t1 21UNION 22SELECT id, 'mx', HEX(LIKE_RANGE_MAX(a, 16)) AS max FROM t1 23UNION 24SELECT id, 'sp', REPEAT('-', 32) AS sep FROM t1 25ORDER BY id, name; 26SELECT * FROM v1; 27id name val 281 a 291 mn 301 mx 311 sp -------------------------------- 322 a _ 332 mn 00 342 mx FF 352 sp -------------------------------- 363 a % 373 mn 383 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 393 sp -------------------------------- 404 a \_ 414 mn 5F 424 mx 5F 434 sp -------------------------------- 445 a \% 455 mn 25 465 mx 25 475 sp -------------------------------- 486 a \ 496 mn 5C 506 mx 5C 516 sp -------------------------------- 527 a a 537 mn 61 547 mx 61 557 sp -------------------------------- 568 a c 578 mn 63 588 mx 63 598 sp -------------------------------- 609 a a_ 619 mn 6100 629 mx 61FF 639 sp -------------------------------- 6410 a c_ 6510 mn 6300 6610 mx 63FF 6710 sp -------------------------------- 6811 a a% 6911 mn 61 7011 mx 61FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 7111 sp -------------------------------- 7212 a c% 7312 mn 63 7412 mx 63FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 7512 sp -------------------------------- 7613 a aa 7713 mn 6161 7813 mx 6161 7913 sp -------------------------------- 8014 a cc 8114 mn 6363 8214 mx 6363 8314 sp -------------------------------- 8415 a ch 8515 mn 6368 8615 mx 6368 8715 sp -------------------------------- 8816 a aa_ 8916 mn 616100 9016 mx 6161FF 9116 sp -------------------------------- 9217 a cc_ 9317 mn 636300 9417 mx 6363FF 9517 sp -------------------------------- 9618 a ch_ 9718 mn 636800 9818 mx 6368FF 9918 sp -------------------------------- 10019 a aa% 10119 mn 6161 10219 mx 6161FFFFFFFFFFFFFFFFFFFFFFFFFFFF 10319 sp -------------------------------- 10420 a cc% 10520 mn 6363 10620 mx 6363FFFFFFFFFFFFFFFFFFFFFFFFFFFF 10720 sp -------------------------------- 10821 a ch% 10921 mn 6368 11021 mx 6368FFFFFFFFFFFFFFFFFFFFFFFFFFFF 11121 sp -------------------------------- 11222 a aaa 11322 mn 616161 11422 mx 616161 11522 sp -------------------------------- 11623 a ccc 11723 mn 636363 11823 mx 636363 11923 sp -------------------------------- 12024 a cch 12124 mn 636368 12224 mx 636368 12324 sp -------------------------------- 12425 a aaa_ 12525 mn 61616100 12625 mx 616161FF 12725 sp -------------------------------- 12826 a ccc_ 12926 mn 63636300 13026 mx 636363FF 13126 sp -------------------------------- 13227 a cch_ 13327 mn 63636800 13427 mx 636368FF 13527 sp -------------------------------- 13628 a aaa% 13728 mn 616161 13828 mx 616161FFFFFFFFFFFFFFFFFFFFFFFFFF 13928 sp -------------------------------- 14029 a ccc% 14129 mn 636363 14229 mx 636363FFFFFFFFFFFFFFFFFFFFFFFFFF 14329 sp -------------------------------- 14430 a cch% 14530 mn 636368 14630 mx 636368FFFFFFFFFFFFFFFFFFFFFFFFFF 14730 sp -------------------------------- 14831 a aaaaaaaaaaaaaaaaaaaa 14931 mn 61616161616161616161616161616161 15031 mx 61616161616161616161616161616161 15131 sp -------------------------------- 15232 a caaaaaaaaaaaaaaaaaaa 15332 mn 63616161616161616161616161616161 15432 mx 63616161616161616161616161616161 15532 sp -------------------------------- 156ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET latin1; 157SELECT * FROM v1; 158id name val 1591 a 1601 mn 1611 mx 1621 sp -------------------------------- 1632 a _ 1642 mn 00 1652 mx FF 1662 sp -------------------------------- 1673 a % 1683 mn 00000000000000000000000000000000 1693 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 1703 sp -------------------------------- 1714 a \_ 1724 mn 5F 1734 mx 5F 1744 sp -------------------------------- 1755 a \% 1765 mn 25 1775 mx 25 1785 sp -------------------------------- 1796 a \ 1806 mn 5C 1816 mx 5C 1826 sp -------------------------------- 1837 a a 1847 mn 61 1857 mx 61 1867 sp -------------------------------- 1878 a c 1888 mn 63 1898 mx 63 1908 sp -------------------------------- 1919 a a_ 1929 mn 6100 1939 mx 61FF 1949 sp -------------------------------- 19510 a c_ 19610 mn 6300 19710 mx 63FF 19810 sp -------------------------------- 19911 a a% 20011 mn 61000000000000000000000000000000 20111 mx 61FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 20211 sp -------------------------------- 20312 a c% 20412 mn 63000000000000000000000000000000 20512 mx 63FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 20612 sp -------------------------------- 20713 a aa 20813 mn 6161 20913 mx 6161 21013 sp -------------------------------- 21114 a cc 21214 mn 6363 21314 mx 6363 21414 sp -------------------------------- 21515 a ch 21615 mn 6368 21715 mx 6368 21815 sp -------------------------------- 21916 a aa_ 22016 mn 616100 22116 mx 6161FF 22216 sp -------------------------------- 22317 a cc_ 22417 mn 636300 22517 mx 6363FF 22617 sp -------------------------------- 22718 a ch_ 22818 mn 636800 22918 mx 6368FF 23018 sp -------------------------------- 23119 a aa% 23219 mn 61610000000000000000000000000000 23319 mx 6161FFFFFFFFFFFFFFFFFFFFFFFFFFFF 23419 sp -------------------------------- 23520 a cc% 23620 mn 63630000000000000000000000000000 23720 mx 6363FFFFFFFFFFFFFFFFFFFFFFFFFFFF 23820 sp -------------------------------- 23921 a ch% 24021 mn 63680000000000000000000000000000 24121 mx 6368FFFFFFFFFFFFFFFFFFFFFFFFFFFF 24221 sp -------------------------------- 24322 a aaa 24422 mn 616161 24522 mx 616161 24622 sp -------------------------------- 24723 a ccc 24823 mn 636363 24923 mx 636363 25023 sp -------------------------------- 25124 a cch 25224 mn 636368 25324 mx 636368 25424 sp -------------------------------- 25525 a aaa_ 25625 mn 61616100 25725 mx 616161FF 25825 sp -------------------------------- 25926 a ccc_ 26026 mn 63636300 26126 mx 636363FF 26226 sp -------------------------------- 26327 a cch_ 26427 mn 63636800 26527 mx 636368FF 26627 sp -------------------------------- 26728 a aaa% 26828 mn 61616100000000000000000000000000 26928 mx 616161FFFFFFFFFFFFFFFFFFFFFFFFFF 27028 sp -------------------------------- 27129 a ccc% 27229 mn 63636300000000000000000000000000 27329 mx 636363FFFFFFFFFFFFFFFFFFFFFFFFFF 27429 sp -------------------------------- 27530 a cch% 27630 mn 63636800000000000000000000000000 27730 mx 636368FFFFFFFFFFFFFFFFFFFFFFFFFF 27830 sp -------------------------------- 27931 a aaaaaaaaaaaaaaaaaaaa 28031 mn 61616161616161616161616161616161 28131 mx 61616161616161616161616161616161 28231 sp -------------------------------- 28332 a caaaaaaaaaaaaaaaaaaa 28432 mn 63616161616161616161616161616161 28532 mx 63616161616161616161616161616161 28632 sp -------------------------------- 287ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8; 288INSERT INTO t1 (a) VALUES (_ucs2 0x0425),(_ucs2 0x045F); 289INSERT INTO t1 (a) VALUES (_ucs2 0x2525),(_ucs2 0x5F5F); 290SELECT * FROM v1; 291id name val 2921 a 2931 mn 2941 mx 2951 sp -------------------------------- 2962 a _ 2972 mn 00000000000000000000000000000000 2982 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2992 sp -------------------------------- 3003 a % 3013 mn 00000000000000000000000000000000 3023 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3033 sp -------------------------------- 3044 a \_ 3054 mn 5F 3064 mx 5F 3074 sp -------------------------------- 3085 a \% 3095 mn 25 3105 mx 25 3115 sp -------------------------------- 3126 a \ 3136 mn 5C 3146 mx 5C 3156 sp -------------------------------- 3167 a a 3177 mn 61 3187 mx 61 3197 sp -------------------------------- 3208 a c 3218 mn 63 3228 mx 63 3238 sp -------------------------------- 3249 a a_ 3259 mn 61000000000000000000000000000000 3269 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 3279 sp -------------------------------- 32810 a c_ 32910 mn 63000000000000000000000000000000 33010 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 33110 sp -------------------------------- 33211 a a% 33311 mn 61000000000000000000000000000000 33411 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 33511 sp -------------------------------- 33612 a c% 33712 mn 63000000000000000000000000000000 33812 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 33912 sp -------------------------------- 34013 a aa 34113 mn 6161 34213 mx 6161 34313 sp -------------------------------- 34414 a cc 34514 mn 6363 34614 mx 6363 34714 sp -------------------------------- 34815 a ch 34915 mn 6368 35015 mx 6368 35115 sp -------------------------------- 35216 a aa_ 35316 mn 61610000000000000000000000000000 35416 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 35516 sp -------------------------------- 35617 a cc_ 35717 mn 63630000000000000000000000000000 35817 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 35917 sp -------------------------------- 36018 a ch_ 36118 mn 63680000000000000000000000000000 36218 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 36318 sp -------------------------------- 36419 a aa% 36519 mn 61610000000000000000000000000000 36619 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 36719 sp -------------------------------- 36820 a cc% 36920 mn 63630000000000000000000000000000 37020 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 37120 sp -------------------------------- 37221 a ch% 37321 mn 63680000000000000000000000000000 37421 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 37521 sp -------------------------------- 37622 a aaa 37722 mn 616161 37822 mx 616161 37922 sp -------------------------------- 38023 a ccc 38123 mn 636363 38223 mx 636363 38323 sp -------------------------------- 38424 a cch 38524 mn 636368 38624 mx 636368 38724 sp -------------------------------- 38825 a aaa_ 38925 mn 61616100000000000000000000000000 39025 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 39125 sp -------------------------------- 39226 a ccc_ 39326 mn 63636300000000000000000000000000 39426 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 39526 sp -------------------------------- 39627 a cch_ 39727 mn 63636800000000000000000000000000 39827 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 39927 sp -------------------------------- 40028 a aaa% 40128 mn 61616100000000000000000000000000 40228 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 40328 sp -------------------------------- 40429 a ccc% 40529 mn 63636300000000000000000000000000 40629 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 40729 sp -------------------------------- 40830 a cch% 40930 mn 63636800000000000000000000000000 41030 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 41130 sp -------------------------------- 41231 a aaaaaaaaaaaaaaaaaaaa 41331 mn 6161616161 41431 mx 6161616161 41531 sp -------------------------------- 41632 a caaaaaaaaaaaaaaaaaaa 41732 mn 6361616161 41832 mx 6361616161 41932 sp -------------------------------- 42033 a Х 42133 mn D0A5 42233 mx D0A5 42333 sp -------------------------------- 42434 a џ 42534 mn D19F 42634 mx D19F 42734 sp -------------------------------- 42835 a ┥ 42935 mn E294A5 43035 mx E294A5 43135 sp -------------------------------- 43236 a 彟 43336 mn E5BD9F 43436 mx E5BD9F 43536 sp -------------------------------- 436ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci; 437SELECT * FROM v1; 438id name val 4391 a 4401 mn 4411 mx 4421 sp -------------------------------- 4432 a _ 4442 mn 09090909090909090909090909090909 4452 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 4462 sp -------------------------------- 4473 a % 4483 mn 09090909090909090909090909090909 4493 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 4503 sp -------------------------------- 4514 a \_ 4524 mn 5F 4534 mx 5F 4544 sp -------------------------------- 4555 a \% 4565 mn 25 4575 mx 25 4585 sp -------------------------------- 4596 a \ 4606 mn 5C 4616 mx 5C 4626 sp -------------------------------- 4637 a a 4647 mn 61 4657 mx 61 4667 sp -------------------------------- 4678 a c 4688 mn 63 4698 mx 63 4708 sp -------------------------------- 4719 a a_ 4729 mn 61090909090909090909090909090909 4739 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 4749 sp -------------------------------- 47510 a c_ 47610 mn 63090909090909090909090909090909 47710 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 47810 sp -------------------------------- 47911 a a% 48011 mn 61090909090909090909090909090909 48111 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 48211 sp -------------------------------- 48312 a c% 48412 mn 63090909090909090909090909090909 48512 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 48612 sp -------------------------------- 48713 a aa 48813 mn 6161 48913 mx 6161 49013 sp -------------------------------- 49114 a cc 49214 mn 6363 49314 mx 6363 49414 sp -------------------------------- 49515 a ch 49615 mn 6368 49715 mx 6368 49815 sp -------------------------------- 49916 a aa_ 50016 mn 61610909090909090909090909090909 50116 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 50216 sp -------------------------------- 50317 a cc_ 50417 mn 63630909090909090909090909090909 50517 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 50617 sp -------------------------------- 50718 a ch_ 50818 mn 63680909090909090909090909090909 50918 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 51018 sp -------------------------------- 51119 a aa% 51219 mn 61610909090909090909090909090909 51319 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 51419 sp -------------------------------- 51520 a cc% 51620 mn 63630909090909090909090909090909 51720 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 51820 sp -------------------------------- 51921 a ch% 52021 mn 63680909090909090909090909090909 52121 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 52221 sp -------------------------------- 52322 a aaa 52422 mn 616161 52522 mx 616161 52622 sp -------------------------------- 52723 a ccc 52823 mn 636363 52923 mx 636363 53023 sp -------------------------------- 53124 a cch 53224 mn 636368 53324 mx 636368 53424 sp -------------------------------- 53525 a aaa_ 53625 mn 61616109090909090909090909090909 53725 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 53825 sp -------------------------------- 53926 a ccc_ 54026 mn 63636309090909090909090909090909 54126 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 54226 sp -------------------------------- 54327 a cch_ 54427 mn 63636809090909090909090909090909 54527 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 54627 sp -------------------------------- 54728 a aaa% 54828 mn 61616109090909090909090909090909 54928 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 55028 sp -------------------------------- 55129 a ccc% 55229 mn 63636309090909090909090909090909 55329 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 55429 sp -------------------------------- 55530 a cch% 55630 mn 63636809090909090909090909090909 55730 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 55830 sp -------------------------------- 55931 a aaaaaaaaaaaaaaaaaaaa 56031 mn 6161616161 56131 mx 6161616161 56231 sp -------------------------------- 56332 a caaaaaaaaaaaaaaaaaaa 56432 mn 6361616161 56532 mx 6361616161 56632 sp -------------------------------- 56733 a Х 56833 mn D0A5 56933 mx D0A5 57033 sp -------------------------------- 57134 a џ 57234 mn D19F 57334 mx D19F 57434 sp -------------------------------- 57535 a ┥ 57635 mn E294A5 57735 mx E294A5 57835 sp -------------------------------- 57936 a 彟 58036 mn E5BD9F 58136 mx E5BD9F 58236 sp -------------------------------- 583ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_czech_ci; 584SELECT * FROM v1; 585id name val 5861 a 5871 mn 5881 mx 5891 sp -------------------------------- 5902 a _ 5912 mn 09090909090909090909090909090909 5922 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 5932 sp -------------------------------- 5943 a % 5953 mn 09090909090909090909090909090909 5963 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 5973 sp -------------------------------- 5984 a \_ 5994 mn 5F 6004 mx 5F 6014 sp -------------------------------- 6025 a \% 6035 mn 25 6045 mx 25 6055 sp -------------------------------- 6066 a \ 6076 mn 5C 6086 mx 5C 6096 sp -------------------------------- 6107 a a 6117 mn 61 6127 mx 61 6137 sp -------------------------------- 6148 a c 6158 mn 63 6168 mx 63 6178 sp -------------------------------- 6189 a a_ 6199 mn 61090909090909090909090909090909 6209 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 6219 sp -------------------------------- 62210 a c_ 62310 mn 09090909090909090909090909090909 62410 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 62510 sp -------------------------------- 62611 a a% 62711 mn 61090909090909090909090909090909 62811 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 62911 sp -------------------------------- 63012 a c% 63112 mn 09090909090909090909090909090909 63212 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 63312 sp -------------------------------- 63413 a aa 63513 mn 6161 63613 mx 6161 63713 sp -------------------------------- 63814 a cc 63914 mn 6363 64014 mx 6363 64114 sp -------------------------------- 64215 a ch 64315 mn 6368 64415 mx 6368 64515 sp -------------------------------- 64616 a aa_ 64716 mn 61610909090909090909090909090909 64816 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 64916 sp -------------------------------- 65017 a cc_ 65117 mn 63090909090909090909090909090909 65217 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 65317 sp -------------------------------- 65418 a ch_ 65518 mn 63680909090909090909090909090909 65618 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 65718 sp -------------------------------- 65819 a aa% 65919 mn 61610909090909090909090909090909 66019 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 66119 sp -------------------------------- 66220 a cc% 66320 mn 63090909090909090909090909090909 66420 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 66520 sp -------------------------------- 66621 a ch% 66721 mn 63680909090909090909090909090909 66821 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 66921 sp -------------------------------- 67022 a aaa 67122 mn 616161 67222 mx 616161 67322 sp -------------------------------- 67423 a ccc 67523 mn 636363 67623 mx 636363 67723 sp -------------------------------- 67824 a cch 67924 mn 636368 68024 mx 636368 68124 sp -------------------------------- 68225 a aaa_ 68325 mn 61616109090909090909090909090909 68425 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 68525 sp -------------------------------- 68626 a ccc_ 68726 mn 63630909090909090909090909090909 68826 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 68926 sp -------------------------------- 69027 a cch_ 69127 mn 63636809090909090909090909090909 69227 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 69327 sp -------------------------------- 69428 a aaa% 69528 mn 61616109090909090909090909090909 69628 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 69728 sp -------------------------------- 69829 a ccc% 69929 mn 63630909090909090909090909090909 70029 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 70129 sp -------------------------------- 70230 a cch% 70330 mn 63636809090909090909090909090909 70430 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 70530 sp -------------------------------- 70631 a aaaaaaaaaaaaaaaaaaaa 70731 mn 6161616161 70831 mx 6161616161 70931 sp -------------------------------- 71032 a caaaaaaaaaaaaaaaaaaa 71132 mn 6361616161 71232 mx 6361616161 71332 sp -------------------------------- 71433 a Х 71533 mn D0A5 71633 mx D0A5 71733 sp -------------------------------- 71834 a џ 71934 mn D19F 72034 mx D19F 72134 sp -------------------------------- 72235 a ┥ 72335 mn E294A5 72435 mx E294A5 72535 sp -------------------------------- 72636 a 彟 72736 mn E5BD9F 72836 mx E5BD9F 72936 sp -------------------------------- 730ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_danish_ci; 731SELECT * FROM v1; 732id name val 7331 a 7341 mn 7351 mx 7361 sp -------------------------------- 7372 a _ 7382 mn 09090909090909090909090909090909 7392 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 7402 sp -------------------------------- 7413 a % 7423 mn 09090909090909090909090909090909 7433 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 7443 sp -------------------------------- 7454 a \_ 7464 mn 5F 7474 mx 5F 7484 sp -------------------------------- 7495 a \% 7505 mn 25 7515 mx 25 7525 sp -------------------------------- 7536 a \ 7546 mn 5C 7556 mx 5C 7566 sp -------------------------------- 7577 a a 7587 mn 61 7597 mx 61 7607 sp -------------------------------- 7618 a c 7628 mn 63 7638 mx 63 7648 sp -------------------------------- 7659 a a_ 7669 mn 09090909090909090909090909090909 7679 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 7689 sp -------------------------------- 76910 a c_ 77010 mn 63090909090909090909090909090909 77110 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 77210 sp -------------------------------- 77311 a a% 77411 mn 09090909090909090909090909090909 77511 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 77611 sp -------------------------------- 77712 a c% 77812 mn 63090909090909090909090909090909 77912 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 78012 sp -------------------------------- 78113 a aa 78213 mn 6161 78313 mx 6161 78413 sp -------------------------------- 78514 a cc 78614 mn 6363 78714 mx 6363 78814 sp -------------------------------- 78915 a ch 79015 mn 6368 79115 mx 6368 79215 sp -------------------------------- 79316 a aa_ 79416 mn 61610909090909090909090909090909 79516 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 79616 sp -------------------------------- 79717 a cc_ 79817 mn 63630909090909090909090909090909 79917 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 80017 sp -------------------------------- 80118 a ch_ 80218 mn 63680909090909090909090909090909 80318 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 80418 sp -------------------------------- 80519 a aa% 80619 mn 61610909090909090909090909090909 80719 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 80819 sp -------------------------------- 80920 a cc% 81020 mn 63630909090909090909090909090909 81120 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 81220 sp -------------------------------- 81321 a ch% 81421 mn 63680909090909090909090909090909 81521 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 81621 sp -------------------------------- 81722 a aaa 81822 mn 616161 81922 mx 616161 82022 sp -------------------------------- 82123 a ccc 82223 mn 636363 82323 mx 636363 82423 sp -------------------------------- 82524 a cch 82624 mn 636368 82724 mx 636368 82824 sp -------------------------------- 82925 a aaa_ 83025 mn 61610909090909090909090909090909 83125 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 83225 sp -------------------------------- 83326 a ccc_ 83426 mn 63636309090909090909090909090909 83526 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 83626 sp -------------------------------- 83727 a cch_ 83827 mn 63636809090909090909090909090909 83927 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 84027 sp -------------------------------- 84128 a aaa% 84228 mn 61610909090909090909090909090909 84328 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 84428 sp -------------------------------- 84529 a ccc% 84629 mn 63636309090909090909090909090909 84729 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 84829 sp -------------------------------- 84930 a cch% 85030 mn 63636809090909090909090909090909 85130 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 85230 sp -------------------------------- 85331 a aaaaaaaaaaaaaaaaaaaa 85431 mn 61616161090909090909090909090909 85531 mx 61616161EFBFBFEFBFBFEFBFBFEFBFBF 85631 sp -------------------------------- 85732 a caaaaaaaaaaaaaaaaaaa 85832 mn 6361616161 85932 mx 6361616161 86032 sp -------------------------------- 86133 a Х 86233 mn D0A5 86333 mx D0A5 86433 sp -------------------------------- 86534 a џ 86634 mn D19F 86734 mx D19F 86834 sp -------------------------------- 86935 a ┥ 87035 mn E294A5 87135 mx E294A5 87235 sp -------------------------------- 87336 a 彟 87436 mn E5BD9F 87536 mx E5BD9F 87636 sp -------------------------------- 877ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_thai_520_w2; 878SELECT * FROM v1; 879id name val 8801 a 8811 mn 8821 mx 8831 sp -------------------------------- 8842 a _ 8852 mn 09 8862 mx EFBFBF 8872 sp -------------------------------- 8883 a % 8893 mn 09090909090909090909090909090909 8903 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 8913 sp -------------------------------- 8924 a \_ 8934 mn 5F 8944 mx 5F 8954 sp -------------------------------- 8965 a \% 8975 mn 25 8985 mx 25 8995 sp -------------------------------- 9006 a \ 9016 mn 5C 9026 mx 5C 9036 sp -------------------------------- 9047 a a 9057 mn 61 9067 mx 61 9077 sp -------------------------------- 9088 a c 9098 mn 63 9108 mx 63 9118 sp -------------------------------- 9129 a a_ 9139 mn 6109 9149 mx 61EFBFBF 9159 sp -------------------------------- 91610 a c_ 91710 mn 6309 91810 mx 63EFBFBF 91910 sp -------------------------------- 92011 a a% 92111 mn 61090909090909090909090909090909 92211 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 92311 sp -------------------------------- 92412 a c% 92512 mn 63090909090909090909090909090909 92612 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 92712 sp -------------------------------- 92813 a aa 92913 mn 6161 93013 mx 6161 93113 sp -------------------------------- 93214 a cc 93314 mn 6363 93414 mx 6363 93514 sp -------------------------------- 93615 a ch 93715 mn 6368 93815 mx 6368 93915 sp -------------------------------- 94016 a aa_ 94116 mn 616109 94216 mx 6161EFBFBF 94316 sp -------------------------------- 94417 a cc_ 94517 mn 636309 94617 mx 6363EFBFBF 94717 sp -------------------------------- 94818 a ch_ 94918 mn 636809 95018 mx 6368EFBFBF 95118 sp -------------------------------- 95219 a aa% 95319 mn 61610909090909090909090909090909 95419 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 95519 sp -------------------------------- 95620 a cc% 95720 mn 63630909090909090909090909090909 95820 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 95920 sp -------------------------------- 96021 a ch% 96121 mn 63680909090909090909090909090909 96221 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 96321 sp -------------------------------- 96422 a aaa 96522 mn 616161 96622 mx 616161 96722 sp -------------------------------- 96823 a ccc 96923 mn 636363 97023 mx 636363 97123 sp -------------------------------- 97224 a cch 97324 mn 636368 97424 mx 636368 97524 sp -------------------------------- 97625 a aaa_ 97725 mn 61616109 97825 mx 616161EFBFBF 97925 sp -------------------------------- 98026 a ccc_ 98126 mn 63636309 98226 mx 636363EFBFBF 98326 sp -------------------------------- 98427 a cch_ 98527 mn 63636809 98627 mx 636368EFBFBF 98727 sp -------------------------------- 98828 a aaa% 98928 mn 61616109090909090909090909090909 99028 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 99128 sp -------------------------------- 99229 a ccc% 99329 mn 63636309090909090909090909090909 99429 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 99529 sp -------------------------------- 99630 a cch% 99730 mn 63636809090909090909090909090909 99830 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 99930 sp -------------------------------- 100031 a aaaaaaaaaaaaaaaaaaaa 100131 mn 6161616161 100231 mx 6161616161 100331 sp -------------------------------- 100432 a caaaaaaaaaaaaaaaaaaa 100532 mn 6361616161 100632 mx 6361616161 100732 sp -------------------------------- 100833 a Х 100933 mn D0A5 101033 mx D0A5 101133 sp -------------------------------- 101234 a џ 101334 mn D19F 101434 mx D19F 101534 sp -------------------------------- 101635 a ┥ 101735 mn E294A5 101835 mx E294A5 101935 sp -------------------------------- 102036 a 彟 102136 mn E5BD9F 102236 mx E5BD9F 102336 sp -------------------------------- 1024ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4; 1025SELECT * FROM v1; 1026id name val 10271 a 10281 mn 10291 mx 10301 sp -------------------------------- 10312 a _ 10322 mn 00000000000000000000000000000000 10332 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 10342 sp -------------------------------- 10353 a % 10363 mn 00000000000000000000000000000000 10373 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 10383 sp -------------------------------- 10394 a \_ 10404 mn 5F 10414 mx 5F 10424 sp -------------------------------- 10435 a \% 10445 mn 25 10455 mx 25 10465 sp -------------------------------- 10476 a \ 10486 mn 5C 10496 mx 5C 10506 sp -------------------------------- 10517 a a 10527 mn 61 10537 mx 61 10547 sp -------------------------------- 10558 a c 10568 mn 63 10578 mx 63 10588 sp -------------------------------- 10599 a a_ 10609 mn 61000000000000000000000000000000 10619 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 10629 sp -------------------------------- 106310 a c_ 106410 mn 63000000000000000000000000000000 106510 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 106610 sp -------------------------------- 106711 a a% 106811 mn 61000000000000000000000000000000 106911 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 107011 sp -------------------------------- 107112 a c% 107212 mn 63000000000000000000000000000000 107312 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 107412 sp -------------------------------- 107513 a aa 107613 mn 6161 107713 mx 6161 107813 sp -------------------------------- 107914 a cc 108014 mn 6363 108114 mx 6363 108214 sp -------------------------------- 108315 a ch 108415 mn 6368 108515 mx 6368 108615 sp -------------------------------- 108716 a aa_ 108816 mn 61610000000000000000000000000000 108916 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 109016 sp -------------------------------- 109117 a cc_ 109217 mn 63630000000000000000000000000000 109317 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 109417 sp -------------------------------- 109518 a ch_ 109618 mn 63680000000000000000000000000000 109718 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 109818 sp -------------------------------- 109919 a aa% 110019 mn 61610000000000000000000000000000 110119 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 110219 sp -------------------------------- 110320 a cc% 110420 mn 63630000000000000000000000000000 110520 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 110620 sp -------------------------------- 110721 a ch% 110821 mn 63680000000000000000000000000000 110921 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 111021 sp -------------------------------- 111122 a aaa 111222 mn 616161 111322 mx 616161 111422 sp -------------------------------- 111523 a ccc 111623 mn 636363 111723 mx 636363 111823 sp -------------------------------- 111924 a cch 112024 mn 636368 112124 mx 636368 112224 sp -------------------------------- 112325 a aaa_ 112425 mn 61616100000000000000000000000000 112525 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 112625 sp -------------------------------- 112726 a ccc_ 112826 mn 63636300000000000000000000000000 112926 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 113026 sp -------------------------------- 113127 a cch_ 113227 mn 63636800000000000000000000000000 113327 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 113427 sp -------------------------------- 113528 a aaa% 113628 mn 61616100000000000000000000000000 113728 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 113828 sp -------------------------------- 113929 a ccc% 114029 mn 63636300000000000000000000000000 114129 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 114229 sp -------------------------------- 114330 a cch% 114430 mn 63636800000000000000000000000000 114530 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 114630 sp -------------------------------- 114731 a aaaaaaaaaaaaaaaaaaaa 114831 mn 61616161 114931 mx 61616161 115031 sp -------------------------------- 115132 a caaaaaaaaaaaaaaaaaaa 115232 mn 63616161 115332 mx 63616161 115432 sp -------------------------------- 115533 a Х 115633 mn D0A5 115733 mx D0A5 115833 sp -------------------------------- 115934 a џ 116034 mn D19F 116134 mx D19F 116234 sp -------------------------------- 116335 a ┥ 116435 mn E294A5 116535 mx E294A5 116635 sp -------------------------------- 116736 a 彟 116836 mn E5BD9F 116936 mx E5BD9F 117036 sp -------------------------------- 1171ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; 1172SELECT * FROM v1; 1173id name val 11741 a 11751 mn 11761 mx 11771 sp -------------------------------- 11782 a _ 11792 mn 09090909090909090909090909090909 11802 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 11812 sp -------------------------------- 11823 a % 11833 mn 09090909090909090909090909090909 11843 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 11853 sp -------------------------------- 11864 a \_ 11874 mn 5F 11884 mx 5F 11894 sp -------------------------------- 11905 a \% 11915 mn 25 11925 mx 25 11935 sp -------------------------------- 11946 a \ 11956 mn 5C 11966 mx 5C 11976 sp -------------------------------- 11987 a a 11997 mn 61 12007 mx 61 12017 sp -------------------------------- 12028 a c 12038 mn 63 12048 mx 63 12058 sp -------------------------------- 12069 a a_ 12079 mn 61090909090909090909090909090909 12089 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 12099 sp -------------------------------- 121010 a c_ 121110 mn 63090909090909090909090909090909 121210 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 121310 sp -------------------------------- 121411 a a% 121511 mn 61090909090909090909090909090909 121611 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 121711 sp -------------------------------- 121812 a c% 121912 mn 63090909090909090909090909090909 122012 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 122112 sp -------------------------------- 122213 a aa 122313 mn 6161 122413 mx 6161 122513 sp -------------------------------- 122614 a cc 122714 mn 6363 122814 mx 6363 122914 sp -------------------------------- 123015 a ch 123115 mn 6368 123215 mx 6368 123315 sp -------------------------------- 123416 a aa_ 123516 mn 61610909090909090909090909090909 123616 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 123716 sp -------------------------------- 123817 a cc_ 123917 mn 63630909090909090909090909090909 124017 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 124117 sp -------------------------------- 124218 a ch_ 124318 mn 63680909090909090909090909090909 124418 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 124518 sp -------------------------------- 124619 a aa% 124719 mn 61610909090909090909090909090909 124819 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 124919 sp -------------------------------- 125020 a cc% 125120 mn 63630909090909090909090909090909 125220 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 125320 sp -------------------------------- 125421 a ch% 125521 mn 63680909090909090909090909090909 125621 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 125721 sp -------------------------------- 125822 a aaa 125922 mn 616161 126022 mx 616161 126122 sp -------------------------------- 126223 a ccc 126323 mn 636363 126423 mx 636363 126523 sp -------------------------------- 126624 a cch 126724 mn 636368 126824 mx 636368 126924 sp -------------------------------- 127025 a aaa_ 127125 mn 61616109090909090909090909090909 127225 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 127325 sp -------------------------------- 127426 a ccc_ 127526 mn 63636309090909090909090909090909 127626 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 127726 sp -------------------------------- 127827 a cch_ 127927 mn 63636809090909090909090909090909 128027 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 128127 sp -------------------------------- 128228 a aaa% 128328 mn 61616109090909090909090909090909 128428 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 128528 sp -------------------------------- 128629 a ccc% 128729 mn 63636309090909090909090909090909 128829 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 128929 sp -------------------------------- 129030 a cch% 129130 mn 63636809090909090909090909090909 129230 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 129330 sp -------------------------------- 129431 a aaaaaaaaaaaaaaaaaaaa 129531 mn 61616161 129631 mx 61616161 129731 sp -------------------------------- 129832 a caaaaaaaaaaaaaaaaaaa 129932 mn 63616161 130032 mx 63616161 130132 sp -------------------------------- 130233 a Х 130333 mn D0A5 130433 mx D0A5 130533 sp -------------------------------- 130634 a џ 130734 mn D19F 130834 mx D19F 130934 sp -------------------------------- 131035 a ┥ 131135 mn E294A5 131235 mx E294A5 131335 sp -------------------------------- 131436 a 彟 131536 mn E5BD9F 131636 mx E5BD9F 131736 sp -------------------------------- 1318ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci; 1319SELECT * FROM v1; 1320id name val 13211 a 13221 mn 13231 mx 13241 sp -------------------------------- 13252 a _ 13262 mn 09090909090909090909090909090909 13272 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 13282 sp -------------------------------- 13293 a % 13303 mn 09090909090909090909090909090909 13313 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 13323 sp -------------------------------- 13334 a \_ 13344 mn 5F 13354 mx 5F 13364 sp -------------------------------- 13375 a \% 13385 mn 25 13395 mx 25 13405 sp -------------------------------- 13416 a \ 13426 mn 5C 13436 mx 5C 13446 sp -------------------------------- 13457 a a 13467 mn 61 13477 mx 61 13487 sp -------------------------------- 13498 a c 13508 mn 63 13518 mx 63 13528 sp -------------------------------- 13539 a a_ 13549 mn 61090909090909090909090909090909 13559 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 13569 sp -------------------------------- 135710 a c_ 135810 mn 09090909090909090909090909090909 135910 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 136010 sp -------------------------------- 136111 a a% 136211 mn 61090909090909090909090909090909 136311 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 136411 sp -------------------------------- 136512 a c% 136612 mn 09090909090909090909090909090909 136712 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 136812 sp -------------------------------- 136913 a aa 137013 mn 6161 137113 mx 6161 137213 sp -------------------------------- 137314 a cc 137414 mn 6363 137514 mx 6363 137614 sp -------------------------------- 137715 a ch 137815 mn 6368 137915 mx 6368 138015 sp -------------------------------- 138116 a aa_ 138216 mn 61610909090909090909090909090909 138316 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 138416 sp -------------------------------- 138517 a cc_ 138617 mn 63090909090909090909090909090909 138717 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 138817 sp -------------------------------- 138918 a ch_ 139018 mn 63680909090909090909090909090909 139118 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 139218 sp -------------------------------- 139319 a aa% 139419 mn 61610909090909090909090909090909 139519 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 139619 sp -------------------------------- 139720 a cc% 139820 mn 63090909090909090909090909090909 139920 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 140020 sp -------------------------------- 140121 a ch% 140221 mn 63680909090909090909090909090909 140321 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 140421 sp -------------------------------- 140522 a aaa 140622 mn 616161 140722 mx 616161 140822 sp -------------------------------- 140923 a ccc 141023 mn 636363 141123 mx 636363 141223 sp -------------------------------- 141324 a cch 141424 mn 636368 141524 mx 636368 141624 sp -------------------------------- 141725 a aaa_ 141825 mn 61616109090909090909090909090909 141925 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 142025 sp -------------------------------- 142126 a ccc_ 142226 mn 63630909090909090909090909090909 142326 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 142426 sp -------------------------------- 142527 a cch_ 142627 mn 63636809090909090909090909090909 142727 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 142827 sp -------------------------------- 142928 a aaa% 143028 mn 61616109090909090909090909090909 143128 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 143228 sp -------------------------------- 143329 a ccc% 143429 mn 63630909090909090909090909090909 143529 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 143629 sp -------------------------------- 143730 a cch% 143830 mn 63636809090909090909090909090909 143930 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 144030 sp -------------------------------- 144131 a aaaaaaaaaaaaaaaaaaaa 144231 mn 61616161 144331 mx 61616161 144431 sp -------------------------------- 144532 a caaaaaaaaaaaaaaaaaaa 144632 mn 63616161 144732 mx 63616161 144832 sp -------------------------------- 144933 a Х 145033 mn D0A5 145133 mx D0A5 145233 sp -------------------------------- 145334 a џ 145434 mn D19F 145534 mx D19F 145634 sp -------------------------------- 145735 a ┥ 145835 mn E294A5 145935 mx E294A5 146035 sp -------------------------------- 146136 a 彟 146236 mn E5BD9F 146336 mx E5BD9F 146436 sp -------------------------------- 1465ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci; 1466SELECT * FROM v1; 1467id name val 14681 a 14691 mn 14701 mx 14711 sp -------------------------------- 14722 a _ 14732 mn 09090909090909090909090909090909 14742 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 14752 sp -------------------------------- 14763 a % 14773 mn 09090909090909090909090909090909 14783 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 14793 sp -------------------------------- 14804 a \_ 14814 mn 5F 14824 mx 5F 14834 sp -------------------------------- 14845 a \% 14855 mn 25 14865 mx 25 14875 sp -------------------------------- 14886 a \ 14896 mn 5C 14906 mx 5C 14916 sp -------------------------------- 14927 a a 14937 mn 61 14947 mx 61 14957 sp -------------------------------- 14968 a c 14978 mn 63 14988 mx 63 14998 sp -------------------------------- 15009 a a_ 15019 mn 09090909090909090909090909090909 15029 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 15039 sp -------------------------------- 150410 a c_ 150510 mn 63090909090909090909090909090909 150610 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 150710 sp -------------------------------- 150811 a a% 150911 mn 09090909090909090909090909090909 151011 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 151111 sp -------------------------------- 151212 a c% 151312 mn 63090909090909090909090909090909 151412 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 151512 sp -------------------------------- 151613 a aa 151713 mn 6161 151813 mx 6161 151913 sp -------------------------------- 152014 a cc 152114 mn 6363 152214 mx 6363 152314 sp -------------------------------- 152415 a ch 152515 mn 6368 152615 mx 6368 152715 sp -------------------------------- 152816 a aa_ 152916 mn 61610909090909090909090909090909 153016 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 153116 sp -------------------------------- 153217 a cc_ 153317 mn 63630909090909090909090909090909 153417 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 153517 sp -------------------------------- 153618 a ch_ 153718 mn 63680909090909090909090909090909 153818 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 153918 sp -------------------------------- 154019 a aa% 154119 mn 61610909090909090909090909090909 154219 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 154319 sp -------------------------------- 154420 a cc% 154520 mn 63630909090909090909090909090909 154620 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 154720 sp -------------------------------- 154821 a ch% 154921 mn 63680909090909090909090909090909 155021 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 155121 sp -------------------------------- 155222 a aaa 155322 mn 616161 155422 mx 616161 155522 sp -------------------------------- 155623 a ccc 155723 mn 636363 155823 mx 636363 155923 sp -------------------------------- 156024 a cch 156124 mn 636368 156224 mx 636368 156324 sp -------------------------------- 156425 a aaa_ 156525 mn 61610909090909090909090909090909 156625 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 156725 sp -------------------------------- 156826 a ccc_ 156926 mn 63636309090909090909090909090909 157026 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 157126 sp -------------------------------- 157227 a cch_ 157327 mn 63636809090909090909090909090909 157427 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 157527 sp -------------------------------- 157628 a aaa% 157728 mn 61610909090909090909090909090909 157828 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 157928 sp -------------------------------- 158029 a ccc% 158129 mn 63636309090909090909090909090909 158229 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 158329 sp -------------------------------- 158430 a cch% 158530 mn 63636809090909090909090909090909 158630 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 158730 sp -------------------------------- 158831 a aaaaaaaaaaaaaaaaaaaa 158931 mn 61616161 159031 mx 61616161 159131 sp -------------------------------- 159232 a caaaaaaaaaaaaaaaaaaa 159332 mn 63616109090909090909090909090909 159432 mx 636161EFBFBFEFBFBFEFBFBFEFBFBF20 159532 sp -------------------------------- 159633 a Х 159733 mn D0A5 159833 mx D0A5 159933 sp -------------------------------- 160034 a џ 160134 mn D19F 160234 mx D19F 160334 sp -------------------------------- 160435 a ┥ 160535 mn E294A5 160635 mx E294A5 160735 sp -------------------------------- 160836 a 彟 160936 mn E5BD9F 161036 mx E5BD9F 161136 sp -------------------------------- 1612ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_thai_520_w2; 1613SELECT * FROM v1; 1614id name val 16151 a 16161 mn 16171 mx 16181 sp -------------------------------- 16192 a _ 16202 mn 09 16212 mx EFBFBF 16222 sp -------------------------------- 16233 a % 16243 mn 09090909090909090909090909090909 16253 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 16263 sp -------------------------------- 16274 a \_ 16284 mn 5F 16294 mx 5F 16304 sp -------------------------------- 16315 a \% 16325 mn 25 16335 mx 25 16345 sp -------------------------------- 16356 a \ 16366 mn 5C 16376 mx 5C 16386 sp -------------------------------- 16397 a a 16407 mn 61 16417 mx 61 16427 sp -------------------------------- 16438 a c 16448 mn 63 16458 mx 63 16468 sp -------------------------------- 16479 a a_ 16489 mn 6109 16499 mx 61EFBFBF 16509 sp -------------------------------- 165110 a c_ 165210 mn 6309 165310 mx 63EFBFBF 165410 sp -------------------------------- 165511 a a% 165611 mn 61090909090909090909090909090909 165711 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 165811 sp -------------------------------- 165912 a c% 166012 mn 63090909090909090909090909090909 166112 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 166212 sp -------------------------------- 166313 a aa 166413 mn 6161 166513 mx 6161 166613 sp -------------------------------- 166714 a cc 166814 mn 6363 166914 mx 6363 167014 sp -------------------------------- 167115 a ch 167215 mn 6368 167315 mx 6368 167415 sp -------------------------------- 167516 a aa_ 167616 mn 616109 167716 mx 6161EFBFBF 167816 sp -------------------------------- 167917 a cc_ 168017 mn 636309 168117 mx 6363EFBFBF 168217 sp -------------------------------- 168318 a ch_ 168418 mn 636809 168518 mx 6368EFBFBF 168618 sp -------------------------------- 168719 a aa% 168819 mn 61610909090909090909090909090909 168919 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 169019 sp -------------------------------- 169120 a cc% 169220 mn 63630909090909090909090909090909 169320 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 169420 sp -------------------------------- 169521 a ch% 169621 mn 63680909090909090909090909090909 169721 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 169821 sp -------------------------------- 169922 a aaa 170022 mn 616161 170122 mx 616161 170222 sp -------------------------------- 170323 a ccc 170423 mn 636363 170523 mx 636363 170623 sp -------------------------------- 170724 a cch 170824 mn 636368 170924 mx 636368 171024 sp -------------------------------- 171125 a aaa_ 171225 mn 61616109 171325 mx 616161EFBFBF 171425 sp -------------------------------- 171526 a ccc_ 171626 mn 63636309 171726 mx 636363EFBFBF 171826 sp -------------------------------- 171927 a cch_ 172027 mn 63636809 172127 mx 636368EFBFBF 172227 sp -------------------------------- 172328 a aaa% 172428 mn 61616109090909090909090909090909 172528 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 172628 sp -------------------------------- 172729 a ccc% 172829 mn 63636309090909090909090909090909 172929 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 173029 sp -------------------------------- 173130 a cch% 173230 mn 63636809090909090909090909090909 173330 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 173430 sp -------------------------------- 173531 a aaaaaaaaaaaaaaaaaaaa 173631 mn 61616161 173731 mx 61616161 173831 sp -------------------------------- 173932 a caaaaaaaaaaaaaaaaaaa 174032 mn 63616161 174132 mx 63616161 174232 sp -------------------------------- 174333 a Х 174433 mn D0A5 174533 mx D0A5 174633 sp -------------------------------- 174734 a џ 174834 mn D19F 174934 mx D19F 175034 sp -------------------------------- 175135 a ┥ 175235 mn E294A5 175335 mx E294A5 175435 sp -------------------------------- 175536 a 彟 175636 mn E5BD9F 175736 mx E5BD9F 175836 sp -------------------------------- 1759ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; 1760SELECT * FROM v1; 1761id name val 17621 a 17631 mn 17641 mx 17651 sp -------------------------------- 17662 a _ 17672 mn 09090909090909090909090909090909 17682 mx F48FBFBFF48FBFBFF48FBFBFF48FBFBF 17692 sp -------------------------------- 17703 a % 17713 mn 09090909090909090909090909090909 17723 mx F48FBFBFF48FBFBFF48FBFBFF48FBFBF 17733 sp -------------------------------- 17744 a \_ 17754 mn 5F 17764 mx 5F 17774 sp -------------------------------- 17785 a \% 17795 mn 25 17805 mx 25 17815 sp -------------------------------- 17826 a \ 17836 mn 5C 17846 mx 5C 17856 sp -------------------------------- 17867 a a 17877 mn 61 17887 mx 61 17897 sp -------------------------------- 17908 a c 17918 mn 63 17928 mx 63 17938 sp -------------------------------- 17949 a a_ 17959 mn 61090909090909090909090909090909 17969 mx 61F48FBFBFF48FBFBFF48FBFBF202020 17979 sp -------------------------------- 179810 a c_ 179910 mn 63090909090909090909090909090909 180010 mx 63F48FBFBFF48FBFBFF48FBFBF202020 180110 sp -------------------------------- 180211 a a% 180311 mn 61090909090909090909090909090909 180411 mx 61F48FBFBFF48FBFBFF48FBFBF202020 180511 sp -------------------------------- 180612 a c% 180712 mn 63090909090909090909090909090909 180812 mx 63F48FBFBFF48FBFBFF48FBFBF202020 180912 sp -------------------------------- 181013 a aa 181113 mn 6161 181213 mx 6161 181313 sp -------------------------------- 181414 a cc 181514 mn 6363 181614 mx 6363 181714 sp -------------------------------- 181815 a ch 181915 mn 6368 182015 mx 6368 182115 sp -------------------------------- 182216 a aa_ 182316 mn 61610909090909090909090909090909 182416 mx 6161F48FBFBFF48FBFBFF48FBFBF2020 182516 sp -------------------------------- 182617 a cc_ 182717 mn 63630909090909090909090909090909 182817 mx 6363F48FBFBFF48FBFBFF48FBFBF2020 182917 sp -------------------------------- 183018 a ch_ 183118 mn 63680909090909090909090909090909 183218 mx 6368F48FBFBFF48FBFBFF48FBFBF2020 183318 sp -------------------------------- 183419 a aa% 183519 mn 61610909090909090909090909090909 183619 mx 6161F48FBFBFF48FBFBFF48FBFBF2020 183719 sp -------------------------------- 183820 a cc% 183920 mn 63630909090909090909090909090909 184020 mx 6363F48FBFBFF48FBFBFF48FBFBF2020 184120 sp -------------------------------- 184221 a ch% 184321 mn 63680909090909090909090909090909 184421 mx 6368F48FBFBFF48FBFBFF48FBFBF2020 184521 sp -------------------------------- 184622 a aaa 184722 mn 616161 184822 mx 616161 184922 sp -------------------------------- 185023 a ccc 185123 mn 636363 185223 mx 636363 185323 sp -------------------------------- 185424 a cch 185524 mn 636368 185624 mx 636368 185724 sp -------------------------------- 185825 a aaa_ 185925 mn 61616109090909090909090909090909 186025 mx 616161F48FBFBFF48FBFBFF48FBFBF20 186125 sp -------------------------------- 186226 a ccc_ 186326 mn 63636309090909090909090909090909 186426 mx 636363F48FBFBFF48FBFBFF48FBFBF20 186526 sp -------------------------------- 186627 a cch_ 186727 mn 63636809090909090909090909090909 186827 mx 636368F48FBFBFF48FBFBFF48FBFBF20 186927 sp -------------------------------- 187028 a aaa% 187128 mn 61616109090909090909090909090909 187228 mx 616161F48FBFBFF48FBFBFF48FBFBF20 187328 sp -------------------------------- 187429 a ccc% 187529 mn 63636309090909090909090909090909 187629 mx 636363F48FBFBFF48FBFBFF48FBFBF20 187729 sp -------------------------------- 187830 a cch% 187930 mn 63636809090909090909090909090909 188030 mx 636368F48FBFBFF48FBFBFF48FBFBF20 188130 sp -------------------------------- 188231 a aaaaaaaaaaaaaaaaaaaa 188331 mn 61616161 188431 mx 61616161 188531 sp -------------------------------- 188632 a caaaaaaaaaaaaaaaaaaa 188732 mn 63616161 188832 mx 63616161 188932 sp -------------------------------- 189033 a Х 189133 mn D0A5 189233 mx D0A5 189333 sp -------------------------------- 189434 a џ 189534 mn D19F 189634 mx D19F 189734 sp -------------------------------- 189835 a ┥ 189935 mn E294A5 190035 mx E294A5 190135 sp -------------------------------- 190236 a 彟 190336 mn E5BD9F 190436 mx E5BD9F 190536 sp -------------------------------- 1906ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2; 1907SELECT * FROM v1; 1908id name val 19091 a 19101 mn 19111 mx 19121 sp -------------------------------- 19132 a _ 19142 mn 0000 19152 mx FFFF 19162 sp -------------------------------- 19173 a % 19183 mn 00000000000000000000000000000000 19193 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 19203 sp -------------------------------- 19214 a \_ 19224 mn 005F 19234 mx 005F 19244 sp -------------------------------- 19255 a \% 19265 mn 0025 19275 mx 0025 19285 sp -------------------------------- 19296 a \ 19306 mn 005C 19316 mx 005C 19326 sp -------------------------------- 19337 a a 19347 mn 0061 19357 mx 0061 19367 sp -------------------------------- 19378 a c 19388 mn 0063 19398 mx 0063 19408 sp -------------------------------- 19419 a a_ 19429 mn 00610000 19439 mx 0061FFFF 19449 sp -------------------------------- 194510 a c_ 194610 mn 00630000 194710 mx 0063FFFF 194810 sp -------------------------------- 194911 a a% 195011 mn 00610000000000000000000000000000 195111 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 195211 sp -------------------------------- 195312 a c% 195412 mn 00630000000000000000000000000000 195512 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 195612 sp -------------------------------- 195713 a aa 195813 mn 00610061 195913 mx 00610061 196013 sp -------------------------------- 196114 a cc 196214 mn 00630063 196314 mx 00630063 196414 sp -------------------------------- 196515 a ch 196615 mn 00630068 196715 mx 00630068 196815 sp -------------------------------- 196916 a aa_ 197016 mn 006100610000 197116 mx 00610061FFFF 197216 sp -------------------------------- 197317 a cc_ 197417 mn 006300630000 197517 mx 00630063FFFF 197617 sp -------------------------------- 197718 a ch_ 197818 mn 006300680000 197918 mx 00630068FFFF 198018 sp -------------------------------- 198119 a aa% 198219 mn 00610061000000000000000000000000 198319 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 198419 sp -------------------------------- 198520 a cc% 198620 mn 00630063000000000000000000000000 198720 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 198820 sp -------------------------------- 198921 a ch% 199021 mn 00630068000000000000000000000000 199121 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 199221 sp -------------------------------- 199322 a aaa 199422 mn 006100610061 199522 mx 006100610061 199622 sp -------------------------------- 199723 a ccc 199823 mn 006300630063 199923 mx 006300630063 200023 sp -------------------------------- 200124 a cch 200224 mn 006300630068 200324 mx 006300630068 200424 sp -------------------------------- 200525 a aaa_ 200625 mn 0061006100610000 200725 mx 006100610061FFFF 200825 sp -------------------------------- 200926 a ccc_ 201026 mn 0063006300630000 201126 mx 006300630063FFFF 201226 sp -------------------------------- 201327 a cch_ 201427 mn 0063006300680000 201527 mx 006300630068FFFF 201627 sp -------------------------------- 201728 a aaa% 201828 mn 00610061006100000000000000000000 201928 mx 006100610061FFFFFFFFFFFFFFFFFFFF 202028 sp -------------------------------- 202129 a ccc% 202229 mn 00630063006300000000000000000000 202329 mx 006300630063FFFFFFFFFFFFFFFFFFFF 202429 sp -------------------------------- 202530 a cch% 202630 mn 00630063006800000000000000000000 202730 mx 006300630068FFFFFFFFFFFFFFFFFFFF 202830 sp -------------------------------- 202931 a aaaaaaaaaaaaaaaaaaaa 203031 mn 00610061006100610061006100610061 203131 mx 00610061006100610061006100610061 203231 sp -------------------------------- 203332 a caaaaaaaaaaaaaaaaaaa 203432 mn 00630061006100610061006100610061 203532 mx 00630061006100610061006100610061 203632 sp -------------------------------- 203733 a Х 203833 mn 0425 203933 mx 0425 204033 sp -------------------------------- 204134 a џ 204234 mn 045F 204334 mx 045F 204434 sp -------------------------------- 204535 a ┥ 204635 mn 2525 204735 mx 2525 204835 sp -------------------------------- 204936 a 彟 205036 mn 5F5F 205136 mx 5F5F 205236 sp -------------------------------- 2053ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_unicode_ci; 2054SELECT * FROM v1; 2055id name val 20561 a 20571 mn 20581 mx 20591 sp -------------------------------- 20602 a _ 20612 mn 0009 20622 mx FFFF 20632 sp -------------------------------- 20643 a % 20653 mn 00090009000900090009000900090009 20663 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 20673 sp -------------------------------- 20684 a \_ 20694 mn 005F 20704 mx 005F 20714 sp -------------------------------- 20725 a \% 20735 mn 0025 20745 mx 0025 20755 sp -------------------------------- 20766 a \ 20776 mn 005C 20786 mx 005C 20796 sp -------------------------------- 20807 a a 20817 mn 0061 20827 mx 0061 20837 sp -------------------------------- 20848 a c 20858 mn 0063 20868 mx 0063 20878 sp -------------------------------- 20889 a a_ 20899 mn 00610009 20909 mx 0061FFFF 20919 sp -------------------------------- 209210 a c_ 209310 mn 00630009 209410 mx 0063FFFF 209510 sp -------------------------------- 209611 a a% 209711 mn 00610009000900090009000900090009 209811 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 209911 sp -------------------------------- 210012 a c% 210112 mn 00630009000900090009000900090009 210212 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 210312 sp -------------------------------- 210413 a aa 210513 mn 00610061 210613 mx 00610061 210713 sp -------------------------------- 210814 a cc 210914 mn 00630063 211014 mx 00630063 211114 sp -------------------------------- 211215 a ch 211315 mn 00630068 211415 mx 00630068 211515 sp -------------------------------- 211616 a aa_ 211716 mn 006100610009 211816 mx 00610061FFFF 211916 sp -------------------------------- 212017 a cc_ 212117 mn 006300630009 212217 mx 00630063FFFF 212317 sp -------------------------------- 212418 a ch_ 212518 mn 006300680009 212618 mx 00630068FFFF 212718 sp -------------------------------- 212819 a aa% 212919 mn 00610061000900090009000900090009 213019 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 213119 sp -------------------------------- 213220 a cc% 213320 mn 00630063000900090009000900090009 213420 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 213520 sp -------------------------------- 213621 a ch% 213721 mn 00630068000900090009000900090009 213821 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 213921 sp -------------------------------- 214022 a aaa 214122 mn 006100610061 214222 mx 006100610061 214322 sp -------------------------------- 214423 a ccc 214523 mn 006300630063 214623 mx 006300630063 214723 sp -------------------------------- 214824 a cch 214924 mn 006300630068 215024 mx 006300630068 215124 sp -------------------------------- 215225 a aaa_ 215325 mn 0061006100610009 215425 mx 006100610061FFFF 215525 sp -------------------------------- 215626 a ccc_ 215726 mn 0063006300630009 215826 mx 006300630063FFFF 215926 sp -------------------------------- 216027 a cch_ 216127 mn 0063006300680009 216227 mx 006300630068FFFF 216327 sp -------------------------------- 216428 a aaa% 216528 mn 00610061006100090009000900090009 216628 mx 006100610061FFFFFFFFFFFFFFFFFFFF 216728 sp -------------------------------- 216829 a ccc% 216929 mn 00630063006300090009000900090009 217029 mx 006300630063FFFFFFFFFFFFFFFFFFFF 217129 sp -------------------------------- 217230 a cch% 217330 mn 00630063006800090009000900090009 217430 mx 006300630068FFFFFFFFFFFFFFFFFFFF 217530 sp -------------------------------- 217631 a aaaaaaaaaaaaaaaaaaaa 217731 mn 00610061006100610061006100610061 217831 mx 00610061006100610061006100610061 217931 sp -------------------------------- 218032 a caaaaaaaaaaaaaaaaaaa 218132 mn 00630061006100610061006100610061 218232 mx 00630061006100610061006100610061 218332 sp -------------------------------- 218433 a Х 218533 mn 0425 218633 mx 0425 218733 sp -------------------------------- 218834 a џ 218934 mn 045F 219034 mx 045F 219134 sp -------------------------------- 219235 a ┥ 219335 mn 2525 219435 mx 2525 219535 sp -------------------------------- 219636 a 彟 219736 mn 5F5F 219836 mx 5F5F 219936 sp -------------------------------- 2200ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_czech_ci; 2201SELECT * FROM v1; 2202id name val 22031 a 22041 mn 22051 mx 22061 sp -------------------------------- 22072 a _ 22082 mn 0009 22092 mx FFFF 22102 sp -------------------------------- 22113 a % 22123 mn 00090009000900090009000900090009 22133 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 22143 sp -------------------------------- 22154 a \_ 22164 mn 005F 22174 mx 005F 22184 sp -------------------------------- 22195 a \% 22205 mn 0025 22215 mx 0025 22225 sp -------------------------------- 22236 a \ 22246 mn 005C 22256 mx 005C 22266 sp -------------------------------- 22277 a a 22287 mn 0061 22297 mx 0061 22307 sp -------------------------------- 22318 a c 22328 mn 0063 22338 mx 0063 22348 sp -------------------------------- 22359 a a_ 22369 mn 00610009 22379 mx 0061FFFF 22389 sp -------------------------------- 223910 a c_ 224010 mn 00090009000900090009000900090009 224110 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 224210 sp -------------------------------- 224311 a a% 224411 mn 00610009000900090009000900090009 224511 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 224611 sp -------------------------------- 224712 a c% 224812 mn 00090009000900090009000900090009 224912 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 225012 sp -------------------------------- 225113 a aa 225213 mn 00610061 225313 mx 00610061 225413 sp -------------------------------- 225514 a cc 225614 mn 00630063 225714 mx 00630063 225814 sp -------------------------------- 225915 a ch 226015 mn 00630068 226115 mx 00630068 226215 sp -------------------------------- 226316 a aa_ 226416 mn 006100610009 226516 mx 00610061FFFF 226616 sp -------------------------------- 226717 a cc_ 226817 mn 00630009000900090009000900090009 226917 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 227017 sp -------------------------------- 227118 a ch_ 227218 mn 006300680009 227318 mx 00630068FFFF 227418 sp -------------------------------- 227519 a aa% 227619 mn 00610061000900090009000900090009 227719 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 227819 sp -------------------------------- 227920 a cc% 228020 mn 00630009000900090009000900090009 228120 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 228220 sp -------------------------------- 228321 a ch% 228421 mn 00630068000900090009000900090009 228521 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 228621 sp -------------------------------- 228722 a aaa 228822 mn 006100610061 228922 mx 006100610061 229022 sp -------------------------------- 229123 a ccc 229223 mn 006300630063 229323 mx 006300630063 229423 sp -------------------------------- 229524 a cch 229624 mn 006300630068 229724 mx 006300630068 229824 sp -------------------------------- 229925 a aaa_ 230025 mn 0061006100610009 230125 mx 006100610061FFFF 230225 sp -------------------------------- 230326 a ccc_ 230426 mn 00630063000900090009000900090009 230526 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 230626 sp -------------------------------- 230727 a cch_ 230827 mn 0063006300680009 230927 mx 006300630068FFFF 231027 sp -------------------------------- 231128 a aaa% 231228 mn 00610061006100090009000900090009 231328 mx 006100610061FFFFFFFFFFFFFFFFFFFF 231428 sp -------------------------------- 231529 a ccc% 231629 mn 00630063000900090009000900090009 231729 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 231829 sp -------------------------------- 231930 a cch% 232030 mn 00630063006800090009000900090009 232130 mx 006300630068FFFFFFFFFFFFFFFFFFFF 232230 sp -------------------------------- 232331 a aaaaaaaaaaaaaaaaaaaa 232431 mn 00610061006100610061006100610061 232531 mx 00610061006100610061006100610061 232631 sp -------------------------------- 232732 a caaaaaaaaaaaaaaaaaaa 232832 mn 00630061006100610061006100610061 232932 mx 00630061006100610061006100610061 233032 sp -------------------------------- 233133 a Х 233233 mn 0425 233333 mx 0425 233433 sp -------------------------------- 233534 a џ 233634 mn 045F 233734 mx 045F 233834 sp -------------------------------- 233935 a ┥ 234035 mn 2525 234135 mx 2525 234235 sp -------------------------------- 234336 a 彟 234436 mn 5F5F 234536 mx 5F5F 234636 sp -------------------------------- 2347ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_danish_ci; 2348SELECT * FROM v1; 2349id name val 23501 a 23511 mn 23521 mx 23531 sp -------------------------------- 23542 a _ 23552 mn 0009 23562 mx FFFF 23572 sp -------------------------------- 23583 a % 23593 mn 00090009000900090009000900090009 23603 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 23613 sp -------------------------------- 23624 a \_ 23634 mn 005F 23644 mx 005F 23654 sp -------------------------------- 23665 a \% 23675 mn 0025 23685 mx 0025 23695 sp -------------------------------- 23706 a \ 23716 mn 005C 23726 mx 005C 23736 sp -------------------------------- 23747 a a 23757 mn 0061 23767 mx 0061 23777 sp -------------------------------- 23788 a c 23798 mn 0063 23808 mx 0063 23818 sp -------------------------------- 23829 a a_ 23839 mn 00090009000900090009000900090009 23849 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 23859 sp -------------------------------- 238610 a c_ 238710 mn 00630009 238810 mx 0063FFFF 238910 sp -------------------------------- 239011 a a% 239111 mn 00090009000900090009000900090009 239211 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 239311 sp -------------------------------- 239412 a c% 239512 mn 00630009000900090009000900090009 239612 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 239712 sp -------------------------------- 239813 a aa 239913 mn 00610061 240013 mx 00610061 240113 sp -------------------------------- 240214 a cc 240314 mn 00630063 240414 mx 00630063 240514 sp -------------------------------- 240615 a ch 240715 mn 00630068 240815 mx 00630068 240915 sp -------------------------------- 241016 a aa_ 241116 mn 006100610009 241216 mx 00610061FFFF 241316 sp -------------------------------- 241417 a cc_ 241517 mn 006300630009 241617 mx 00630063FFFF 241717 sp -------------------------------- 241818 a ch_ 241918 mn 006300680009 242018 mx 00630068FFFF 242118 sp -------------------------------- 242219 a aa% 242319 mn 00610061000900090009000900090009 242419 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 242519 sp -------------------------------- 242620 a cc% 242720 mn 00630063000900090009000900090009 242820 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 242920 sp -------------------------------- 243021 a ch% 243121 mn 00630068000900090009000900090009 243221 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 243321 sp -------------------------------- 243422 a aaa 243522 mn 006100610061 243622 mx 006100610061 243722 sp -------------------------------- 243823 a ccc 243923 mn 006300630063 244023 mx 006300630063 244123 sp -------------------------------- 244224 a cch 244324 mn 006300630068 244424 mx 006300630068 244524 sp -------------------------------- 244625 a aaa_ 244725 mn 00610061000900090009000900090009 244825 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 244925 sp -------------------------------- 245026 a ccc_ 245126 mn 0063006300630009 245226 mx 006300630063FFFF 245326 sp -------------------------------- 245427 a cch_ 245527 mn 0063006300680009 245627 mx 006300630068FFFF 245727 sp -------------------------------- 245828 a aaa% 245928 mn 00610061000900090009000900090009 246028 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 246128 sp -------------------------------- 246229 a ccc% 246329 mn 00630063006300090009000900090009 246429 mx 006300630063FFFFFFFFFFFFFFFFFFFF 246529 sp -------------------------------- 246630 a cch% 246730 mn 00630063006800090009000900090009 246830 mx 006300630068FFFFFFFFFFFFFFFFFFFF 246930 sp -------------------------------- 247031 a aaaaaaaaaaaaaaaaaaaa 247131 mn 00610061006100610061006100610061 247231 mx 00610061006100610061006100610061 247331 sp -------------------------------- 247432 a caaaaaaaaaaaaaaaaaaa 247532 mn 00630061006100610061006100610009 247632 mx 0063006100610061006100610061FFFF 247732 sp -------------------------------- 247833 a Х 247933 mn 0425 248033 mx 0425 248133 sp -------------------------------- 248234 a џ 248334 mn 045F 248434 mx 045F 248534 sp -------------------------------- 248635 a ┥ 248735 mn 2525 248835 mx 2525 248935 sp -------------------------------- 249036 a 彟 249136 mn 5F5F 249236 mx 5F5F 249336 sp -------------------------------- 2494ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_thai_520_w2; 2495SELECT * FROM v1; 2496id name val 24971 a 24981 mn 24991 mx 25001 sp -------------------------------- 25012 a _ 25022 mn 0009 25032 mx FFFF 25042 sp -------------------------------- 25053 a % 25063 mn 00090009000900090009000900090009 25073 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 25083 sp -------------------------------- 25094 a \_ 25104 mn 005F 25114 mx 005F 25124 sp -------------------------------- 25135 a \% 25145 mn 0025 25155 mx 0025 25165 sp -------------------------------- 25176 a \ 25186 mn 005C 25196 mx 005C 25206 sp -------------------------------- 25217 a a 25227 mn 0061 25237 mx 0061 25247 sp -------------------------------- 25258 a c 25268 mn 0063 25278 mx 0063 25288 sp -------------------------------- 25299 a a_ 25309 mn 00610009 25319 mx 0061FFFF 25329 sp -------------------------------- 253310 a c_ 253410 mn 00630009 253510 mx 0063FFFF 253610 sp -------------------------------- 253711 a a% 253811 mn 00610009000900090009000900090009 253911 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 254011 sp -------------------------------- 254112 a c% 254212 mn 00630009000900090009000900090009 254312 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 254412 sp -------------------------------- 254513 a aa 254613 mn 00610061 254713 mx 00610061 254813 sp -------------------------------- 254914 a cc 255014 mn 00630063 255114 mx 00630063 255214 sp -------------------------------- 255315 a ch 255415 mn 00630068 255515 mx 00630068 255615 sp -------------------------------- 255716 a aa_ 255816 mn 006100610009 255916 mx 00610061FFFF 256016 sp -------------------------------- 256117 a cc_ 256217 mn 006300630009 256317 mx 00630063FFFF 256417 sp -------------------------------- 256518 a ch_ 256618 mn 006300680009 256718 mx 00630068FFFF 256818 sp -------------------------------- 256919 a aa% 257019 mn 00610061000900090009000900090009 257119 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 257219 sp -------------------------------- 257320 a cc% 257420 mn 00630063000900090009000900090009 257520 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 257620 sp -------------------------------- 257721 a ch% 257821 mn 00630068000900090009000900090009 257921 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 258021 sp -------------------------------- 258122 a aaa 258222 mn 006100610061 258322 mx 006100610061 258422 sp -------------------------------- 258523 a ccc 258623 mn 006300630063 258723 mx 006300630063 258823 sp -------------------------------- 258924 a cch 259024 mn 006300630068 259124 mx 006300630068 259224 sp -------------------------------- 259325 a aaa_ 259425 mn 0061006100610009 259525 mx 006100610061FFFF 259625 sp -------------------------------- 259726 a ccc_ 259826 mn 0063006300630009 259926 mx 006300630063FFFF 260026 sp -------------------------------- 260127 a cch_ 260227 mn 0063006300680009 260327 mx 006300630068FFFF 260427 sp -------------------------------- 260528 a aaa% 260628 mn 00610061006100090009000900090009 260728 mx 006100610061FFFFFFFFFFFFFFFFFFFF 260828 sp -------------------------------- 260929 a ccc% 261029 mn 00630063006300090009000900090009 261129 mx 006300630063FFFFFFFFFFFFFFFFFFFF 261229 sp -------------------------------- 261330 a cch% 261430 mn 00630063006800090009000900090009 261530 mx 006300630068FFFFFFFFFFFFFFFFFFFF 261630 sp -------------------------------- 261731 a aaaaaaaaaaaaaaaaaaaa 261831 mn 00610061006100610061006100610061 261931 mx 00610061006100610061006100610061 262031 sp -------------------------------- 262132 a caaaaaaaaaaaaaaaaaaa 262232 mn 00630061006100610061006100610061 262332 mx 00630061006100610061006100610061 262432 sp -------------------------------- 262533 a Х 262633 mn 0425 262733 mx 0425 262833 sp -------------------------------- 262934 a џ 263034 mn 045F 263134 mx 045F 263234 sp -------------------------------- 263335 a ┥ 263435 mn 2525 263535 mx 2525 263635 sp -------------------------------- 263736 a 彟 263836 mn 5F5F 263936 mx 5F5F 264036 sp -------------------------------- 2641ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16; 2642SELECT * FROM v1; 2643id name val 26441 a 26451 mn 26461 mx 26471 sp -------------------------------- 26482 a _ 26492 mn 0000 26502 mx FFFF 26512 sp -------------------------------- 26523 a % 26533 mn 00000000000000000000000000000000 26543 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 26553 sp -------------------------------- 26564 a \_ 26574 mn 005F 26584 mx 005F 26594 sp -------------------------------- 26605 a \% 26615 mn 0025 26625 mx 0025 26635 sp -------------------------------- 26646 a \ 26656 mn 005C 26666 mx 005C 26676 sp -------------------------------- 26687 a a 26697 mn 0061 26707 mx 0061 26717 sp -------------------------------- 26728 a c 26738 mn 0063 26748 mx 0063 26758 sp -------------------------------- 26769 a a_ 26779 mn 00610000 26789 mx 0061FFFF 26799 sp -------------------------------- 268010 a c_ 268110 mn 00630000 268210 mx 0063FFFF 268310 sp -------------------------------- 268411 a a% 268511 mn 00610000000000000000000000000000 268611 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 268711 sp -------------------------------- 268812 a c% 268912 mn 00630000000000000000000000000000 269012 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 269112 sp -------------------------------- 269213 a aa 269313 mn 00610061 269413 mx 00610061 269513 sp -------------------------------- 269614 a cc 269714 mn 00630063 269814 mx 00630063 269914 sp -------------------------------- 270015 a ch 270115 mn 00630068 270215 mx 00630068 270315 sp -------------------------------- 270416 a aa_ 270516 mn 006100610000 270616 mx 00610061FFFF 270716 sp -------------------------------- 270817 a cc_ 270917 mn 006300630000 271017 mx 00630063FFFF 271117 sp -------------------------------- 271218 a ch_ 271318 mn 006300680000 271418 mx 00630068FFFF 271518 sp -------------------------------- 271619 a aa% 271719 mn 00610061000000000000000000000000 271819 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 271919 sp -------------------------------- 272020 a cc% 272120 mn 00630063000000000000000000000000 272220 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 272320 sp -------------------------------- 272421 a ch% 272521 mn 00630068000000000000000000000000 272621 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 272721 sp -------------------------------- 272822 a aaa 272922 mn 006100610061 273022 mx 006100610061 273122 sp -------------------------------- 273223 a ccc 273323 mn 006300630063 273423 mx 006300630063 273523 sp -------------------------------- 273624 a cch 273724 mn 006300630068 273824 mx 006300630068 273924 sp -------------------------------- 274025 a aaa_ 274125 mn 0061006100610000 274225 mx 006100610061FFFF 274325 sp -------------------------------- 274426 a ccc_ 274526 mn 0063006300630000 274626 mx 006300630063FFFF 274726 sp -------------------------------- 274827 a cch_ 274927 mn 0063006300680000 275027 mx 006300630068FFFF 275127 sp -------------------------------- 275228 a aaa% 275328 mn 00610061006100000000000000000000 275428 mx 006100610061FFFFFFFFFFFFFFFFFFFF 275528 sp -------------------------------- 275629 a ccc% 275729 mn 00630063006300000000000000000000 275829 mx 006300630063FFFFFFFFFFFFFFFFFFFF 275929 sp -------------------------------- 276030 a cch% 276130 mn 00630063006800000000000000000000 276230 mx 006300630068FFFFFFFFFFFFFFFFFFFF 276330 sp -------------------------------- 276431 a aaaaaaaaaaaaaaaaaaaa 276531 mn 0061006100610061 276631 mx 0061006100610061 276731 sp -------------------------------- 276832 a caaaaaaaaaaaaaaaaaaa 276932 mn 0063006100610061 277032 mx 0063006100610061 277132 sp -------------------------------- 277233 a Х 277333 mn 0425 277433 mx 0425 277533 sp -------------------------------- 277634 a џ 277734 mn 045F 277834 mx 045F 277934 sp -------------------------------- 278035 a ┥ 278135 mn 2525 278235 mx 2525 278335 sp -------------------------------- 278436 a 彟 278536 mn 5F5F 278636 mx 5F5F 278736 sp -------------------------------- 2788ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_unicode_ci; 2789SELECT * FROM v1; 2790id name val 27911 a 27921 mn 27931 mx 27941 sp -------------------------------- 27952 a _ 27962 mn 0009 27972 mx FFFF 27982 sp -------------------------------- 27993 a % 28003 mn 00090009000900090009000900090009 28013 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 28023 sp -------------------------------- 28034 a \_ 28044 mn 005F 28054 mx 005F 28064 sp -------------------------------- 28075 a \% 28085 mn 0025 28095 mx 0025 28105 sp -------------------------------- 28116 a \ 28126 mn 005C 28136 mx 005C 28146 sp -------------------------------- 28157 a a 28167 mn 0061 28177 mx 0061 28187 sp -------------------------------- 28198 a c 28208 mn 0063 28218 mx 0063 28228 sp -------------------------------- 28239 a a_ 28249 mn 00610009 28259 mx 0061FFFF 28269 sp -------------------------------- 282710 a c_ 282810 mn 00630009 282910 mx 0063FFFF 283010 sp -------------------------------- 283111 a a% 283211 mn 00610009000900090009000900090009 283311 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 283411 sp -------------------------------- 283512 a c% 283612 mn 00630009000900090009000900090009 283712 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 283812 sp -------------------------------- 283913 a aa 284013 mn 00610061 284113 mx 00610061 284213 sp -------------------------------- 284314 a cc 284414 mn 00630063 284514 mx 00630063 284614 sp -------------------------------- 284715 a ch 284815 mn 00630068 284915 mx 00630068 285015 sp -------------------------------- 285116 a aa_ 285216 mn 006100610009 285316 mx 00610061FFFF 285416 sp -------------------------------- 285517 a cc_ 285617 mn 006300630009 285717 mx 00630063FFFF 285817 sp -------------------------------- 285918 a ch_ 286018 mn 006300680009 286118 mx 00630068FFFF 286218 sp -------------------------------- 286319 a aa% 286419 mn 00610061000900090009000900090009 286519 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 286619 sp -------------------------------- 286720 a cc% 286820 mn 00630063000900090009000900090009 286920 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 287020 sp -------------------------------- 287121 a ch% 287221 mn 00630068000900090009000900090009 287321 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 287421 sp -------------------------------- 287522 a aaa 287622 mn 006100610061 287722 mx 006100610061 287822 sp -------------------------------- 287923 a ccc 288023 mn 006300630063 288123 mx 006300630063 288223 sp -------------------------------- 288324 a cch 288424 mn 006300630068 288524 mx 006300630068 288624 sp -------------------------------- 288725 a aaa_ 288825 mn 0061006100610009 288925 mx 006100610061FFFF 289025 sp -------------------------------- 289126 a ccc_ 289226 mn 0063006300630009 289326 mx 006300630063FFFF 289426 sp -------------------------------- 289527 a cch_ 289627 mn 0063006300680009 289727 mx 006300630068FFFF 289827 sp -------------------------------- 289928 a aaa% 290028 mn 00610061006100090009000900090009 290128 mx 006100610061FFFFFFFFFFFFFFFFFFFF 290228 sp -------------------------------- 290329 a ccc% 290429 mn 00630063006300090009000900090009 290529 mx 006300630063FFFFFFFFFFFFFFFFFFFF 290629 sp -------------------------------- 290730 a cch% 290830 mn 00630063006800090009000900090009 290930 mx 006300630068FFFFFFFFFFFFFFFFFFFF 291030 sp -------------------------------- 291131 a aaaaaaaaaaaaaaaaaaaa 291231 mn 0061006100610061 291331 mx 0061006100610061 291431 sp -------------------------------- 291532 a caaaaaaaaaaaaaaaaaaa 291632 mn 0063006100610061 291732 mx 0063006100610061 291832 sp -------------------------------- 291933 a Х 292033 mn 0425 292133 mx 0425 292233 sp -------------------------------- 292334 a џ 292434 mn 045F 292534 mx 045F 292634 sp -------------------------------- 292735 a ┥ 292835 mn 2525 292935 mx 2525 293035 sp -------------------------------- 293136 a 彟 293236 mn 5F5F 293336 mx 5F5F 293436 sp -------------------------------- 2935ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_czech_ci; 2936SELECT * FROM v1; 2937id name val 29381 a 29391 mn 29401 mx 29411 sp -------------------------------- 29422 a _ 29432 mn 0009 29442 mx FFFF 29452 sp -------------------------------- 29463 a % 29473 mn 00090009000900090009000900090009 29483 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 29493 sp -------------------------------- 29504 a \_ 29514 mn 005F 29524 mx 005F 29534 sp -------------------------------- 29545 a \% 29555 mn 0025 29565 mx 0025 29575 sp -------------------------------- 29586 a \ 29596 mn 005C 29606 mx 005C 29616 sp -------------------------------- 29627 a a 29637 mn 0061 29647 mx 0061 29657 sp -------------------------------- 29668 a c 29678 mn 0063 29688 mx 0063 29698 sp -------------------------------- 29709 a a_ 29719 mn 00610009 29729 mx 0061FFFF 29739 sp -------------------------------- 297410 a c_ 297510 mn 00090009000900090009000900090009 297610 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 297710 sp -------------------------------- 297811 a a% 297911 mn 00610009000900090009000900090009 298011 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 298111 sp -------------------------------- 298212 a c% 298312 mn 00090009000900090009000900090009 298412 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 298512 sp -------------------------------- 298613 a aa 298713 mn 00610061 298813 mx 00610061 298913 sp -------------------------------- 299014 a cc 299114 mn 00630063 299214 mx 00630063 299314 sp -------------------------------- 299415 a ch 299515 mn 00630068 299615 mx 00630068 299715 sp -------------------------------- 299816 a aa_ 299916 mn 006100610009 300016 mx 00610061FFFF 300116 sp -------------------------------- 300217 a cc_ 300317 mn 00630009000900090009000900090009 300417 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 300517 sp -------------------------------- 300618 a ch_ 300718 mn 006300680009 300818 mx 00630068FFFF 300918 sp -------------------------------- 301019 a aa% 301119 mn 00610061000900090009000900090009 301219 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 301319 sp -------------------------------- 301420 a cc% 301520 mn 00630009000900090009000900090009 301620 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 301720 sp -------------------------------- 301821 a ch% 301921 mn 00630068000900090009000900090009 302021 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 302121 sp -------------------------------- 302222 a aaa 302322 mn 006100610061 302422 mx 006100610061 302522 sp -------------------------------- 302623 a ccc 302723 mn 006300630063 302823 mx 006300630063 302923 sp -------------------------------- 303024 a cch 303124 mn 006300630068 303224 mx 006300630068 303324 sp -------------------------------- 303425 a aaa_ 303525 mn 0061006100610009 303625 mx 006100610061FFFF 303725 sp -------------------------------- 303826 a ccc_ 303926 mn 00630063000900090009000900090009 304026 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 304126 sp -------------------------------- 304227 a cch_ 304327 mn 0063006300680009 304427 mx 006300630068FFFF 304527 sp -------------------------------- 304628 a aaa% 304728 mn 00610061006100090009000900090009 304828 mx 006100610061FFFFFFFFFFFFFFFFFFFF 304928 sp -------------------------------- 305029 a ccc% 305129 mn 00630063000900090009000900090009 305229 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 305329 sp -------------------------------- 305430 a cch% 305530 mn 00630063006800090009000900090009 305630 mx 006300630068FFFFFFFFFFFFFFFFFFFF 305730 sp -------------------------------- 305831 a aaaaaaaaaaaaaaaaaaaa 305931 mn 0061006100610061 306031 mx 0061006100610061 306131 sp -------------------------------- 306232 a caaaaaaaaaaaaaaaaaaa 306332 mn 0063006100610061 306432 mx 0063006100610061 306532 sp -------------------------------- 306633 a Х 306733 mn 0425 306833 mx 0425 306933 sp -------------------------------- 307034 a џ 307134 mn 045F 307234 mx 045F 307334 sp -------------------------------- 307435 a ┥ 307535 mn 2525 307635 mx 2525 307735 sp -------------------------------- 307836 a 彟 307936 mn 5F5F 308036 mx 5F5F 308136 sp -------------------------------- 3082ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_danish_ci; 3083SELECT * FROM v1; 3084id name val 30851 a 30861 mn 30871 mx 30881 sp -------------------------------- 30892 a _ 30902 mn 0009 30912 mx FFFF 30922 sp -------------------------------- 30933 a % 30943 mn 00090009000900090009000900090009 30953 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 30963 sp -------------------------------- 30974 a \_ 30984 mn 005F 30994 mx 005F 31004 sp -------------------------------- 31015 a \% 31025 mn 0025 31035 mx 0025 31045 sp -------------------------------- 31056 a \ 31066 mn 005C 31076 mx 005C 31086 sp -------------------------------- 31097 a a 31107 mn 0061 31117 mx 0061 31127 sp -------------------------------- 31138 a c 31148 mn 0063 31158 mx 0063 31168 sp -------------------------------- 31179 a a_ 31189 mn 00090009000900090009000900090009 31199 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 31209 sp -------------------------------- 312110 a c_ 312210 mn 00630009 312310 mx 0063FFFF 312410 sp -------------------------------- 312511 a a% 312611 mn 00090009000900090009000900090009 312711 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 312811 sp -------------------------------- 312912 a c% 313012 mn 00630009000900090009000900090009 313112 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 313212 sp -------------------------------- 313313 a aa 313413 mn 00610061 313513 mx 00610061 313613 sp -------------------------------- 313714 a cc 313814 mn 00630063 313914 mx 00630063 314014 sp -------------------------------- 314115 a ch 314215 mn 00630068 314315 mx 00630068 314415 sp -------------------------------- 314516 a aa_ 314616 mn 006100610009 314716 mx 00610061FFFF 314816 sp -------------------------------- 314917 a cc_ 315017 mn 006300630009 315117 mx 00630063FFFF 315217 sp -------------------------------- 315318 a ch_ 315418 mn 006300680009 315518 mx 00630068FFFF 315618 sp -------------------------------- 315719 a aa% 315819 mn 00610061000900090009000900090009 315919 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 316019 sp -------------------------------- 316120 a cc% 316220 mn 00630063000900090009000900090009 316320 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 316420 sp -------------------------------- 316521 a ch% 316621 mn 00630068000900090009000900090009 316721 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 316821 sp -------------------------------- 316922 a aaa 317022 mn 006100610061 317122 mx 006100610061 317222 sp -------------------------------- 317323 a ccc 317423 mn 006300630063 317523 mx 006300630063 317623 sp -------------------------------- 317724 a cch 317824 mn 006300630068 317924 mx 006300630068 318024 sp -------------------------------- 318125 a aaa_ 318225 mn 00610061000900090009000900090009 318325 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 318425 sp -------------------------------- 318526 a ccc_ 318626 mn 0063006300630009 318726 mx 006300630063FFFF 318826 sp -------------------------------- 318927 a cch_ 319027 mn 0063006300680009 319127 mx 006300630068FFFF 319227 sp -------------------------------- 319328 a aaa% 319428 mn 00610061000900090009000900090009 319528 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 319628 sp -------------------------------- 319729 a ccc% 319829 mn 00630063006300090009000900090009 319929 mx 006300630063FFFFFFFFFFFFFFFFFFFF 320029 sp -------------------------------- 320130 a cch% 320230 mn 00630063006800090009000900090009 320330 mx 006300630068FFFFFFFFFFFFFFFFFFFF 320430 sp -------------------------------- 320531 a aaaaaaaaaaaaaaaaaaaa 320631 mn 0061006100610061 320731 mx 0061006100610061 320831 sp -------------------------------- 320932 a caaaaaaaaaaaaaaaaaaa 321032 mn 00630061006100090009000900090009 321132 mx 006300610061FFFFFFFFFFFFFFFFFFFF 321232 sp -------------------------------- 321333 a Х 321433 mn 0425 321533 mx 0425 321633 sp -------------------------------- 321734 a џ 321834 mn 045F 321934 mx 045F 322034 sp -------------------------------- 322135 a ┥ 322235 mn 2525 322335 mx 2525 322435 sp -------------------------------- 322536 a 彟 322636 mn 5F5F 322736 mx 5F5F 322836 sp -------------------------------- 3229ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_thai_520_w2; 3230SELECT * FROM v1; 3231id name val 32321 a 32331 mn 32341 mx 32351 sp -------------------------------- 32362 a _ 32372 mn 0009 32382 mx FFFF 32392 sp -------------------------------- 32403 a % 32413 mn 00090009000900090009000900090009 32423 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 32433 sp -------------------------------- 32444 a \_ 32454 mn 005F 32464 mx 005F 32474 sp -------------------------------- 32485 a \% 32495 mn 0025 32505 mx 0025 32515 sp -------------------------------- 32526 a \ 32536 mn 005C 32546 mx 005C 32556 sp -------------------------------- 32567 a a 32577 mn 0061 32587 mx 0061 32597 sp -------------------------------- 32608 a c 32618 mn 0063 32628 mx 0063 32638 sp -------------------------------- 32649 a a_ 32659 mn 00610009 32669 mx 0061FFFF 32679 sp -------------------------------- 326810 a c_ 326910 mn 00630009 327010 mx 0063FFFF 327110 sp -------------------------------- 327211 a a% 327311 mn 00610009000900090009000900090009 327411 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 327511 sp -------------------------------- 327612 a c% 327712 mn 00630009000900090009000900090009 327812 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 327912 sp -------------------------------- 328013 a aa 328113 mn 00610061 328213 mx 00610061 328313 sp -------------------------------- 328414 a cc 328514 mn 00630063 328614 mx 00630063 328714 sp -------------------------------- 328815 a ch 328915 mn 00630068 329015 mx 00630068 329115 sp -------------------------------- 329216 a aa_ 329316 mn 006100610009 329416 mx 00610061FFFF 329516 sp -------------------------------- 329617 a cc_ 329717 mn 006300630009 329817 mx 00630063FFFF 329917 sp -------------------------------- 330018 a ch_ 330118 mn 006300680009 330218 mx 00630068FFFF 330318 sp -------------------------------- 330419 a aa% 330519 mn 00610061000900090009000900090009 330619 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 330719 sp -------------------------------- 330820 a cc% 330920 mn 00630063000900090009000900090009 331020 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 331120 sp -------------------------------- 331221 a ch% 331321 mn 00630068000900090009000900090009 331421 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 331521 sp -------------------------------- 331622 a aaa 331722 mn 006100610061 331822 mx 006100610061 331922 sp -------------------------------- 332023 a ccc 332123 mn 006300630063 332223 mx 006300630063 332323 sp -------------------------------- 332424 a cch 332524 mn 006300630068 332624 mx 006300630068 332724 sp -------------------------------- 332825 a aaa_ 332925 mn 0061006100610009 333025 mx 006100610061FFFF 333125 sp -------------------------------- 333226 a ccc_ 333326 mn 0063006300630009 333426 mx 006300630063FFFF 333526 sp -------------------------------- 333627 a cch_ 333727 mn 0063006300680009 333827 mx 006300630068FFFF 333927 sp -------------------------------- 334028 a aaa% 334128 mn 00610061006100090009000900090009 334228 mx 006100610061FFFFFFFFFFFFFFFFFFFF 334328 sp -------------------------------- 334429 a ccc% 334529 mn 00630063006300090009000900090009 334629 mx 006300630063FFFFFFFFFFFFFFFFFFFF 334729 sp -------------------------------- 334830 a cch% 334930 mn 00630063006800090009000900090009 335030 mx 006300630068FFFFFFFFFFFFFFFFFFFF 335130 sp -------------------------------- 335231 a aaaaaaaaaaaaaaaaaaaa 335331 mn 0061006100610061 335431 mx 0061006100610061 335531 sp -------------------------------- 335632 a caaaaaaaaaaaaaaaaaaa 335732 mn 0063006100610061 335832 mx 0063006100610061 335932 sp -------------------------------- 336033 a Х 336133 mn 0425 336233 mx 0425 336333 sp -------------------------------- 336434 a џ 336534 mn 045F 336634 mx 045F 336734 sp -------------------------------- 336835 a ┥ 336935 mn 2525 337035 mx 2525 337135 sp -------------------------------- 337236 a 彟 337336 mn 5F5F 337436 mx 5F5F 337536 sp -------------------------------- 3376ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_unicode_520_ci; 3377SELECT * FROM v1; 3378id name val 33791 a 33801 mn 33811 mx 33821 sp -------------------------------- 33832 a _ 33842 mn 0009 33852 mx DBFFDFFF 33862 sp -------------------------------- 33873 a % 33883 mn 00090009000900090009000900090009 33893 mx DBFFDFFFDBFFDFFFDBFFDFFFDBFFDFFF 33903 sp -------------------------------- 33914 a \_ 33924 mn 005F 33934 mx 005F 33944 sp -------------------------------- 33955 a \% 33965 mn 0025 33975 mx 0025 33985 sp -------------------------------- 33996 a \ 34006 mn 005C 34016 mx 005C 34026 sp -------------------------------- 34037 a a 34047 mn 0061 34057 mx 0061 34067 sp -------------------------------- 34078 a c 34088 mn 0063 34098 mx 0063 34108 sp -------------------------------- 34119 a a_ 34129 mn 00610009 34139 mx 0061DBFFDFFF 34149 sp -------------------------------- 341510 a c_ 341610 mn 00630009 341710 mx 0063DBFFDFFF 341810 sp -------------------------------- 341911 a a% 342011 mn 00610009000900090009000900090009 342111 mx 0061DBFFDFFFDBFFDFFFDBFFDFFF0000 342211 sp -------------------------------- 342312 a c% 342412 mn 00630009000900090009000900090009 342512 mx 0063DBFFDFFFDBFFDFFFDBFFDFFF0000 342612 sp -------------------------------- 342713 a aa 342813 mn 00610061 342913 mx 00610061 343013 sp -------------------------------- 343114 a cc 343214 mn 00630063 343314 mx 00630063 343414 sp -------------------------------- 343515 a ch 343615 mn 00630068 343715 mx 00630068 343815 sp -------------------------------- 343916 a aa_ 344016 mn 006100610009 344116 mx 00610061DBFFDFFF 344216 sp -------------------------------- 344317 a cc_ 344417 mn 006300630009 344517 mx 00630063DBFFDFFF 344617 sp -------------------------------- 344718 a ch_ 344818 mn 006300680009 344918 mx 00630068DBFFDFFF 345018 sp -------------------------------- 345119 a aa% 345219 mn 00610061000900090009000900090009 345319 mx 00610061DBFFDFFFDBFFDFFFDBFFDFFF 345419 sp -------------------------------- 345520 a cc% 345620 mn 00630063000900090009000900090009 345720 mx 00630063DBFFDFFFDBFFDFFFDBFFDFFF 345820 sp -------------------------------- 345921 a ch% 346021 mn 00630068000900090009000900090009 346121 mx 00630068DBFFDFFFDBFFDFFFDBFFDFFF 346221 sp -------------------------------- 346322 a aaa 346422 mn 006100610061 346522 mx 006100610061 346622 sp -------------------------------- 346723 a ccc 346823 mn 006300630063 346923 mx 006300630063 347023 sp -------------------------------- 347124 a cch 347224 mn 006300630068 347324 mx 006300630068 347424 sp -------------------------------- 347525 a aaa_ 347625 mn 0061006100610009 347725 mx 006100610061DBFFDFFF 347825 sp -------------------------------- 347926 a ccc_ 348026 mn 0063006300630009 348126 mx 006300630063DBFFDFFF 348226 sp -------------------------------- 348327 a cch_ 348427 mn 0063006300680009 348527 mx 006300630068DBFFDFFF 348627 sp -------------------------------- 348728 a aaa% 348828 mn 00610061006100090009000900090009 348928 mx 006100610061DBFFDFFFDBFFDFFF0000 349028 sp -------------------------------- 349129 a ccc% 349229 mn 00630063006300090009000900090009 349329 mx 006300630063DBFFDFFFDBFFDFFF0000 349429 sp -------------------------------- 349530 a cch% 349630 mn 00630063006800090009000900090009 349730 mx 006300630068DBFFDFFFDBFFDFFF0000 349830 sp -------------------------------- 349931 a aaaaaaaaaaaaaaaaaaaa 350031 mn 0061006100610061 350131 mx 0061006100610061 350231 sp -------------------------------- 350332 a caaaaaaaaaaaaaaaaaaa 350432 mn 0063006100610061 350532 mx 0063006100610061 350632 sp -------------------------------- 350733 a Х 350833 mn 0425 350933 mx 0425 351033 sp -------------------------------- 351134 a џ 351234 mn 045F 351334 mx 045F 351434 sp -------------------------------- 351535 a ┥ 351635 mn 2525 351735 mx 2525 351835 sp -------------------------------- 351936 a 彟 352036 mn 5F5F 352136 mx 5F5F 352236 sp -------------------------------- 3523ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32; 3524SELECT * FROM v1; 3525id name val 35261 a 35271 mn 35281 mx 35291 sp -------------------------------- 35302 a _ 35312 mn 00000000 35322 mx 0000FFFF 35332 sp -------------------------------- 35343 a % 35353 mn 00000000000000000000000000000000 35363 mx 0000FFFF0000FFFF0000FFFF0000FFFF 35373 sp -------------------------------- 35384 a \_ 35394 mn 0000005F 35404 mx 0000005F 35414 sp -------------------------------- 35425 a \% 35435 mn 00000025 35445 mx 00000025 35455 sp -------------------------------- 35466 a \ 35476 mn 0000005C 35486 mx 0000005C 35496 sp -------------------------------- 35507 a a 35517 mn 00000061 35527 mx 00000061 35537 sp -------------------------------- 35548 a c 35558 mn 00000063 35568 mx 00000063 35578 sp -------------------------------- 35589 a a_ 35599 mn 0000006100000000 35609 mx 000000610000FFFF 35619 sp -------------------------------- 356210 a c_ 356310 mn 0000006300000000 356410 mx 000000630000FFFF 356510 sp -------------------------------- 356611 a a% 356711 mn 00000061000000000000000000000000 356811 mx 000000610000FFFF0000FFFF0000FFFF 356911 sp -------------------------------- 357012 a c% 357112 mn 00000063000000000000000000000000 357212 mx 000000630000FFFF0000FFFF0000FFFF 357312 sp -------------------------------- 357413 a aa 357513 mn 0000006100000061 357613 mx 0000006100000061 357713 sp -------------------------------- 357814 a cc 357914 mn 0000006300000063 358014 mx 0000006300000063 358114 sp -------------------------------- 358215 a ch 358315 mn 0000006300000068 358415 mx 0000006300000068 358515 sp -------------------------------- 358616 a aa_ 358716 mn 000000610000006100000000 358816 mx 00000061000000610000FFFF 358916 sp -------------------------------- 359017 a cc_ 359117 mn 000000630000006300000000 359217 mx 00000063000000630000FFFF 359317 sp -------------------------------- 359418 a ch_ 359518 mn 000000630000006800000000 359618 mx 00000063000000680000FFFF 359718 sp -------------------------------- 359819 a aa% 359919 mn 00000061000000610000000000000000 360019 mx 00000061000000610000FFFF0000FFFF 360119 sp -------------------------------- 360220 a cc% 360320 mn 00000063000000630000000000000000 360420 mx 00000063000000630000FFFF0000FFFF 360520 sp -------------------------------- 360621 a ch% 360721 mn 00000063000000680000000000000000 360821 mx 00000063000000680000FFFF0000FFFF 360921 sp -------------------------------- 361022 a aaa 361122 mn 000000610000006100000061 361222 mx 000000610000006100000061 361322 sp -------------------------------- 361423 a ccc 361523 mn 000000630000006300000063 361623 mx 000000630000006300000063 361723 sp -------------------------------- 361824 a cch 361924 mn 000000630000006300000068 362024 mx 000000630000006300000068 362124 sp -------------------------------- 362225 a aaa_ 362325 mn 00000061000000610000006100000000 362425 mx 0000006100000061000000610000FFFF 362525 sp -------------------------------- 362626 a ccc_ 362726 mn 00000063000000630000006300000000 362826 mx 0000006300000063000000630000FFFF 362926 sp -------------------------------- 363027 a cch_ 363127 mn 00000063000000630000006800000000 363227 mx 0000006300000063000000680000FFFF 363327 sp -------------------------------- 363428 a aaa% 363528 mn 00000061000000610000006100000000 363628 mx 0000006100000061000000610000FFFF 363728 sp -------------------------------- 363829 a ccc% 363929 mn 00000063000000630000006300000000 364029 mx 0000006300000063000000630000FFFF 364129 sp -------------------------------- 364230 a cch% 364330 mn 00000063000000630000006800000000 364430 mx 0000006300000063000000680000FFFF 364530 sp -------------------------------- 364631 a aaaaaaaaaaaaaaaaaaaa 364731 mn 00000061000000610000006100000061 364831 mx 00000061000000610000006100000061 364931 sp -------------------------------- 365032 a caaaaaaaaaaaaaaaaaaa 365132 mn 00000063000000610000006100000061 365232 mx 00000063000000610000006100000061 365332 sp -------------------------------- 365433 a Х 365533 mn 00000425 365633 mx 00000425 365733 sp -------------------------------- 365834 a џ 365934 mn 0000045F 366034 mx 0000045F 366134 sp -------------------------------- 366235 a ┥ 366335 mn 00002525 366435 mx 00002525 366535 sp -------------------------------- 366636 a 彟 366736 mn 00005F5F 366836 mx 00005F5F 366936 sp -------------------------------- 3670ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_unicode_ci; 3671SELECT * FROM v1; 3672id name val 36731 a 36741 mn 36751 mx 36761 sp -------------------------------- 36772 a _ 36782 mn 00000009 36792 mx 0000FFFF 36802 sp -------------------------------- 36813 a % 36823 mn 00000009000000090000000900000009 36833 mx 0000FFFF0000FFFF0000FFFF0000FFFF 36843 sp -------------------------------- 36854 a \_ 36864 mn 0000005F 36874 mx 0000005F 36884 sp -------------------------------- 36895 a \% 36905 mn 00000025 36915 mx 00000025 36925 sp -------------------------------- 36936 a \ 36946 mn 0000005C 36956 mx 0000005C 36966 sp -------------------------------- 36977 a a 36987 mn 00000061 36997 mx 00000061 37007 sp -------------------------------- 37018 a c 37028 mn 00000063 37038 mx 00000063 37048 sp -------------------------------- 37059 a a_ 37069 mn 0000006100000009 37079 mx 000000610000FFFF 37089 sp -------------------------------- 370910 a c_ 371010 mn 0000006300000009 371110 mx 000000630000FFFF 371210 sp -------------------------------- 371311 a a% 371411 mn 00000061000000090000000900000009 371511 mx 000000610000FFFF0000FFFF0000FFFF 371611 sp -------------------------------- 371712 a c% 371812 mn 00000063000000090000000900000009 371912 mx 000000630000FFFF0000FFFF0000FFFF 372012 sp -------------------------------- 372113 a aa 372213 mn 0000006100000061 372313 mx 0000006100000061 372413 sp -------------------------------- 372514 a cc 372614 mn 0000006300000063 372714 mx 0000006300000063 372814 sp -------------------------------- 372915 a ch 373015 mn 0000006300000068 373115 mx 0000006300000068 373215 sp -------------------------------- 373316 a aa_ 373416 mn 000000610000006100000009 373516 mx 00000061000000610000FFFF 373616 sp -------------------------------- 373717 a cc_ 373817 mn 000000630000006300000009 373917 mx 00000063000000630000FFFF 374017 sp -------------------------------- 374118 a ch_ 374218 mn 000000630000006800000009 374318 mx 00000063000000680000FFFF 374418 sp -------------------------------- 374519 a aa% 374619 mn 00000061000000610000000900000009 374719 mx 00000061000000610000FFFF0000FFFF 374819 sp -------------------------------- 374920 a cc% 375020 mn 00000063000000630000000900000009 375120 mx 00000063000000630000FFFF0000FFFF 375220 sp -------------------------------- 375321 a ch% 375421 mn 00000063000000680000000900000009 375521 mx 00000063000000680000FFFF0000FFFF 375621 sp -------------------------------- 375722 a aaa 375822 mn 000000610000006100000061 375922 mx 000000610000006100000061 376022 sp -------------------------------- 376123 a ccc 376223 mn 000000630000006300000063 376323 mx 000000630000006300000063 376423 sp -------------------------------- 376524 a cch 376624 mn 000000630000006300000068 376724 mx 000000630000006300000068 376824 sp -------------------------------- 376925 a aaa_ 377025 mn 00000061000000610000006100000009 377125 mx 0000006100000061000000610000FFFF 377225 sp -------------------------------- 377326 a ccc_ 377426 mn 00000063000000630000006300000009 377526 mx 0000006300000063000000630000FFFF 377626 sp -------------------------------- 377727 a cch_ 377827 mn 00000063000000630000006800000009 377927 mx 0000006300000063000000680000FFFF 378027 sp -------------------------------- 378128 a aaa% 378228 mn 00000061000000610000006100000009 378328 mx 0000006100000061000000610000FFFF 378428 sp -------------------------------- 378529 a ccc% 378629 mn 00000063000000630000006300000009 378729 mx 0000006300000063000000630000FFFF 378829 sp -------------------------------- 378930 a cch% 379030 mn 00000063000000630000006800000009 379130 mx 0000006300000063000000680000FFFF 379230 sp -------------------------------- 379331 a aaaaaaaaaaaaaaaaaaaa 379431 mn 00000061000000610000006100000061 379531 mx 00000061000000610000006100000061 379631 sp -------------------------------- 379732 a caaaaaaaaaaaaaaaaaaa 379832 mn 00000063000000610000006100000061 379932 mx 00000063000000610000006100000061 380032 sp -------------------------------- 380133 a Х 380233 mn 00000425 380333 mx 00000425 380433 sp -------------------------------- 380534 a џ 380634 mn 0000045F 380734 mx 0000045F 380834 sp -------------------------------- 380935 a ┥ 381035 mn 00002525 381135 mx 00002525 381235 sp -------------------------------- 381336 a 彟 381436 mn 00005F5F 381536 mx 00005F5F 381636 sp -------------------------------- 3817ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_czech_ci; 3818SELECT * FROM v1; 3819id name val 38201 a 38211 mn 38221 mx 38231 sp -------------------------------- 38242 a _ 38252 mn 00000009 38262 mx 0000FFFF 38272 sp -------------------------------- 38283 a % 38293 mn 00000009000000090000000900000009 38303 mx 0000FFFF0000FFFF0000FFFF0000FFFF 38313 sp -------------------------------- 38324 a \_ 38334 mn 0000005F 38344 mx 0000005F 38354 sp -------------------------------- 38365 a \% 38375 mn 00000025 38385 mx 00000025 38395 sp -------------------------------- 38406 a \ 38416 mn 0000005C 38426 mx 0000005C 38436 sp -------------------------------- 38447 a a 38457 mn 00000061 38467 mx 00000061 38477 sp -------------------------------- 38488 a c 38498 mn 00000063 38508 mx 00000063 38518 sp -------------------------------- 38529 a a_ 38539 mn 0000006100000009 38549 mx 000000610000FFFF 38559 sp -------------------------------- 385610 a c_ 385710 mn 00000009000000090000000900000009 385810 mx 0000FFFF0000FFFF0000FFFF0000FFFF 385910 sp -------------------------------- 386011 a a% 386111 mn 00000061000000090000000900000009 386211 mx 000000610000FFFF0000FFFF0000FFFF 386311 sp -------------------------------- 386412 a c% 386512 mn 00000009000000090000000900000009 386612 mx 0000FFFF0000FFFF0000FFFF0000FFFF 386712 sp -------------------------------- 386813 a aa 386913 mn 0000006100000061 387013 mx 0000006100000061 387113 sp -------------------------------- 387214 a cc 387314 mn 0000006300000063 387414 mx 0000006300000063 387514 sp -------------------------------- 387615 a ch 387715 mn 0000006300000068 387815 mx 0000006300000068 387915 sp -------------------------------- 388016 a aa_ 388116 mn 000000610000006100000009 388216 mx 00000061000000610000FFFF 388316 sp -------------------------------- 388417 a cc_ 388517 mn 00000063000000090000000900000009 388617 mx 000000630000FFFF0000FFFF0000FFFF 388717 sp -------------------------------- 388818 a ch_ 388918 mn 000000630000006800000009 389018 mx 00000063000000680000FFFF 389118 sp -------------------------------- 389219 a aa% 389319 mn 00000061000000610000000900000009 389419 mx 00000061000000610000FFFF0000FFFF 389519 sp -------------------------------- 389620 a cc% 389720 mn 00000063000000090000000900000009 389820 mx 000000630000FFFF0000FFFF0000FFFF 389920 sp -------------------------------- 390021 a ch% 390121 mn 00000063000000680000000900000009 390221 mx 00000063000000680000FFFF0000FFFF 390321 sp -------------------------------- 390422 a aaa 390522 mn 000000610000006100000061 390622 mx 000000610000006100000061 390722 sp -------------------------------- 390823 a ccc 390923 mn 000000630000006300000063 391023 mx 000000630000006300000063 391123 sp -------------------------------- 391224 a cch 391324 mn 000000630000006300000068 391424 mx 000000630000006300000068 391524 sp -------------------------------- 391625 a aaa_ 391725 mn 00000061000000610000006100000009 391825 mx 0000006100000061000000610000FFFF 391925 sp -------------------------------- 392026 a ccc_ 392126 mn 00000063000000630000000900000009 392226 mx 00000063000000630000FFFF0000FFFF 392326 sp -------------------------------- 392427 a cch_ 392527 mn 00000063000000630000006800000009 392627 mx 0000006300000063000000680000FFFF 392727 sp -------------------------------- 392828 a aaa% 392928 mn 00000061000000610000006100000009 393028 mx 0000006100000061000000610000FFFF 393128 sp -------------------------------- 393229 a ccc% 393329 mn 00000063000000630000000900000009 393429 mx 00000063000000630000FFFF0000FFFF 393529 sp -------------------------------- 393630 a cch% 393730 mn 00000063000000630000006800000009 393830 mx 0000006300000063000000680000FFFF 393930 sp -------------------------------- 394031 a aaaaaaaaaaaaaaaaaaaa 394131 mn 00000061000000610000006100000061 394231 mx 00000061000000610000006100000061 394331 sp -------------------------------- 394432 a caaaaaaaaaaaaaaaaaaa 394532 mn 00000063000000610000006100000061 394632 mx 00000063000000610000006100000061 394732 sp -------------------------------- 394833 a Х 394933 mn 00000425 395033 mx 00000425 395133 sp -------------------------------- 395234 a џ 395334 mn 0000045F 395434 mx 0000045F 395534 sp -------------------------------- 395635 a ┥ 395735 mn 00002525 395835 mx 00002525 395935 sp -------------------------------- 396036 a 彟 396136 mn 00005F5F 396236 mx 00005F5F 396336 sp -------------------------------- 3964ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_danish_ci; 3965SELECT * FROM v1; 3966id name val 39671 a 39681 mn 39691 mx 39701 sp -------------------------------- 39712 a _ 39722 mn 00000009 39732 mx 0000FFFF 39742 sp -------------------------------- 39753 a % 39763 mn 00000009000000090000000900000009 39773 mx 0000FFFF0000FFFF0000FFFF0000FFFF 39783 sp -------------------------------- 39794 a \_ 39804 mn 0000005F 39814 mx 0000005F 39824 sp -------------------------------- 39835 a \% 39845 mn 00000025 39855 mx 00000025 39865 sp -------------------------------- 39876 a \ 39886 mn 0000005C 39896 mx 0000005C 39906 sp -------------------------------- 39917 a a 39927 mn 00000061 39937 mx 00000061 39947 sp -------------------------------- 39958 a c 39968 mn 00000063 39978 mx 00000063 39988 sp -------------------------------- 39999 a a_ 40009 mn 00000009000000090000000900000009 40019 mx 0000FFFF0000FFFF0000FFFF0000FFFF 40029 sp -------------------------------- 400310 a c_ 400410 mn 0000006300000009 400510 mx 000000630000FFFF 400610 sp -------------------------------- 400711 a a% 400811 mn 00000009000000090000000900000009 400911 mx 0000FFFF0000FFFF0000FFFF0000FFFF 401011 sp -------------------------------- 401112 a c% 401212 mn 00000063000000090000000900000009 401312 mx 000000630000FFFF0000FFFF0000FFFF 401412 sp -------------------------------- 401513 a aa 401613 mn 0000006100000061 401713 mx 0000006100000061 401813 sp -------------------------------- 401914 a cc 402014 mn 0000006300000063 402114 mx 0000006300000063 402214 sp -------------------------------- 402315 a ch 402415 mn 0000006300000068 402515 mx 0000006300000068 402615 sp -------------------------------- 402716 a aa_ 402816 mn 000000610000006100000009 402916 mx 00000061000000610000FFFF 403016 sp -------------------------------- 403117 a cc_ 403217 mn 000000630000006300000009 403317 mx 00000063000000630000FFFF 403417 sp -------------------------------- 403518 a ch_ 403618 mn 000000630000006800000009 403718 mx 00000063000000680000FFFF 403818 sp -------------------------------- 403919 a aa% 404019 mn 00000061000000610000000900000009 404119 mx 00000061000000610000FFFF0000FFFF 404219 sp -------------------------------- 404320 a cc% 404420 mn 00000063000000630000000900000009 404520 mx 00000063000000630000FFFF0000FFFF 404620 sp -------------------------------- 404721 a ch% 404821 mn 00000063000000680000000900000009 404921 mx 00000063000000680000FFFF0000FFFF 405021 sp -------------------------------- 405122 a aaa 405222 mn 000000610000006100000061 405322 mx 000000610000006100000061 405422 sp -------------------------------- 405523 a ccc 405623 mn 000000630000006300000063 405723 mx 000000630000006300000063 405823 sp -------------------------------- 405924 a cch 406024 mn 000000630000006300000068 406124 mx 000000630000006300000068 406224 sp -------------------------------- 406325 a aaa_ 406425 mn 00000061000000610000000900000009 406525 mx 00000061000000610000FFFF0000FFFF 406625 sp -------------------------------- 406726 a ccc_ 406826 mn 00000063000000630000006300000009 406926 mx 0000006300000063000000630000FFFF 407026 sp -------------------------------- 407127 a cch_ 407227 mn 00000063000000630000006800000009 407327 mx 0000006300000063000000680000FFFF 407427 sp -------------------------------- 407528 a aaa% 407628 mn 00000061000000610000000900000009 407728 mx 00000061000000610000FFFF0000FFFF 407828 sp -------------------------------- 407929 a ccc% 408029 mn 00000063000000630000006300000009 408129 mx 0000006300000063000000630000FFFF 408229 sp -------------------------------- 408330 a cch% 408430 mn 00000063000000630000006800000009 408530 mx 0000006300000063000000680000FFFF 408630 sp -------------------------------- 408731 a aaaaaaaaaaaaaaaaaaaa 408831 mn 00000061000000610000006100000061 408931 mx 00000061000000610000006100000061 409031 sp -------------------------------- 409132 a caaaaaaaaaaaaaaaaaaa 409232 mn 00000063000000610000006100000009 409332 mx 0000006300000061000000610000FFFF 409432 sp -------------------------------- 409533 a Х 409633 mn 00000425 409733 mx 00000425 409833 sp -------------------------------- 409934 a џ 410034 mn 0000045F 410134 mx 0000045F 410234 sp -------------------------------- 410335 a ┥ 410435 mn 00002525 410535 mx 00002525 410635 sp -------------------------------- 410736 a 彟 410836 mn 00005F5F 410936 mx 00005F5F 411036 sp -------------------------------- 4111ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_thai_520_w2; 4112SELECT * FROM v1; 4113id name val 41141 a 41151 mn 41161 mx 41171 sp -------------------------------- 41182 a _ 41192 mn 00000009 41202 mx 0000FFFF 41212 sp -------------------------------- 41223 a % 41233 mn 00000009000000090000000900000009 41243 mx 0000FFFF0000FFFF0000FFFF0000FFFF 41253 sp -------------------------------- 41264 a \_ 41274 mn 0000005F 41284 mx 0000005F 41294 sp -------------------------------- 41305 a \% 41315 mn 00000025 41325 mx 00000025 41335 sp -------------------------------- 41346 a \ 41356 mn 0000005C 41366 mx 0000005C 41376 sp -------------------------------- 41387 a a 41397 mn 00000061 41407 mx 00000061 41417 sp -------------------------------- 41428 a c 41438 mn 00000063 41448 mx 00000063 41458 sp -------------------------------- 41469 a a_ 41479 mn 0000006100000009 41489 mx 000000610000FFFF 41499 sp -------------------------------- 415010 a c_ 415110 mn 0000006300000009 415210 mx 000000630000FFFF 415310 sp -------------------------------- 415411 a a% 415511 mn 00000061000000090000000900000009 415611 mx 000000610000FFFF0000FFFF0000FFFF 415711 sp -------------------------------- 415812 a c% 415912 mn 00000063000000090000000900000009 416012 mx 000000630000FFFF0000FFFF0000FFFF 416112 sp -------------------------------- 416213 a aa 416313 mn 0000006100000061 416413 mx 0000006100000061 416513 sp -------------------------------- 416614 a cc 416714 mn 0000006300000063 416814 mx 0000006300000063 416914 sp -------------------------------- 417015 a ch 417115 mn 0000006300000068 417215 mx 0000006300000068 417315 sp -------------------------------- 417416 a aa_ 417516 mn 000000610000006100000009 417616 mx 00000061000000610000FFFF 417716 sp -------------------------------- 417817 a cc_ 417917 mn 000000630000006300000009 418017 mx 00000063000000630000FFFF 418117 sp -------------------------------- 418218 a ch_ 418318 mn 000000630000006800000009 418418 mx 00000063000000680000FFFF 418518 sp -------------------------------- 418619 a aa% 418719 mn 00000061000000610000000900000009 418819 mx 00000061000000610000FFFF0000FFFF 418919 sp -------------------------------- 419020 a cc% 419120 mn 00000063000000630000000900000009 419220 mx 00000063000000630000FFFF0000FFFF 419320 sp -------------------------------- 419421 a ch% 419521 mn 00000063000000680000000900000009 419621 mx 00000063000000680000FFFF0000FFFF 419721 sp -------------------------------- 419822 a aaa 419922 mn 000000610000006100000061 420022 mx 000000610000006100000061 420122 sp -------------------------------- 420223 a ccc 420323 mn 000000630000006300000063 420423 mx 000000630000006300000063 420523 sp -------------------------------- 420624 a cch 420724 mn 000000630000006300000068 420824 mx 000000630000006300000068 420924 sp -------------------------------- 421025 a aaa_ 421125 mn 00000061000000610000006100000009 421225 mx 0000006100000061000000610000FFFF 421325 sp -------------------------------- 421426 a ccc_ 421526 mn 00000063000000630000006300000009 421626 mx 0000006300000063000000630000FFFF 421726 sp -------------------------------- 421827 a cch_ 421927 mn 00000063000000630000006800000009 422027 mx 0000006300000063000000680000FFFF 422127 sp -------------------------------- 422228 a aaa% 422328 mn 00000061000000610000006100000009 422428 mx 0000006100000061000000610000FFFF 422528 sp -------------------------------- 422629 a ccc% 422729 mn 00000063000000630000006300000009 422829 mx 0000006300000063000000630000FFFF 422929 sp -------------------------------- 423030 a cch% 423130 mn 00000063000000630000006800000009 423230 mx 0000006300000063000000680000FFFF 423330 sp -------------------------------- 423431 a aaaaaaaaaaaaaaaaaaaa 423531 mn 00000061000000610000006100000061 423631 mx 00000061000000610000006100000061 423731 sp -------------------------------- 423832 a caaaaaaaaaaaaaaaaaaa 423932 mn 00000063000000610000006100000061 424032 mx 00000063000000610000006100000061 424132 sp -------------------------------- 424233 a Х 424333 mn 00000425 424433 mx 00000425 424533 sp -------------------------------- 424634 a џ 424734 mn 0000045F 424834 mx 0000045F 424934 sp -------------------------------- 425035 a ┥ 425135 mn 00002525 425235 mx 00002525 425335 sp -------------------------------- 425436 a 彟 425536 mn 00005F5F 425636 mx 00005F5F 425736 sp -------------------------------- 4258ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_unicode_520_ci; 4259SELECT * FROM v1; 4260id name val 42611 a 42621 mn 42631 mx 42641 sp -------------------------------- 42652 a _ 42662 mn 00000009 42672 mx 0010FFFF 42682 sp -------------------------------- 42693 a % 42703 mn 00000009000000090000000900000009 42713 mx 0010FFFF0010FFFF0010FFFF0010FFFF 42723 sp -------------------------------- 42734 a \_ 42744 mn 0000005F 42754 mx 0000005F 42764 sp -------------------------------- 42775 a \% 42785 mn 00000025 42795 mx 00000025 42805 sp -------------------------------- 42816 a \ 42826 mn 0000005C 42836 mx 0000005C 42846 sp -------------------------------- 42857 a a 42867 mn 00000061 42877 mx 00000061 42887 sp -------------------------------- 42898 a c 42908 mn 00000063 42918 mx 00000063 42928 sp -------------------------------- 42939 a a_ 42949 mn 0000006100000009 42959 mx 000000610010FFFF 42969 sp -------------------------------- 429710 a c_ 429810 mn 0000006300000009 429910 mx 000000630010FFFF 430010 sp -------------------------------- 430111 a a% 430211 mn 00000061000000090000000900000009 430311 mx 000000610010FFFF0010FFFF0010FFFF 430411 sp -------------------------------- 430512 a c% 430612 mn 00000063000000090000000900000009 430712 mx 000000630010FFFF0010FFFF0010FFFF 430812 sp -------------------------------- 430913 a aa 431013 mn 0000006100000061 431113 mx 0000006100000061 431213 sp -------------------------------- 431314 a cc 431414 mn 0000006300000063 431514 mx 0000006300000063 431614 sp -------------------------------- 431715 a ch 431815 mn 0000006300000068 431915 mx 0000006300000068 432015 sp -------------------------------- 432116 a aa_ 432216 mn 000000610000006100000009 432316 mx 00000061000000610010FFFF 432416 sp -------------------------------- 432517 a cc_ 432617 mn 000000630000006300000009 432717 mx 00000063000000630010FFFF 432817 sp -------------------------------- 432918 a ch_ 433018 mn 000000630000006800000009 433118 mx 00000063000000680010FFFF 433218 sp -------------------------------- 433319 a aa% 433419 mn 00000061000000610000000900000009 433519 mx 00000061000000610010FFFF0010FFFF 433619 sp -------------------------------- 433720 a cc% 433820 mn 00000063000000630000000900000009 433920 mx 00000063000000630010FFFF0010FFFF 434020 sp -------------------------------- 434121 a ch% 434221 mn 00000063000000680000000900000009 434321 mx 00000063000000680010FFFF0010FFFF 434421 sp -------------------------------- 434522 a aaa 434622 mn 000000610000006100000061 434722 mx 000000610000006100000061 434822 sp -------------------------------- 434923 a ccc 435023 mn 000000630000006300000063 435123 mx 000000630000006300000063 435223 sp -------------------------------- 435324 a cch 435424 mn 000000630000006300000068 435524 mx 000000630000006300000068 435624 sp -------------------------------- 435725 a aaa_ 435825 mn 00000061000000610000006100000009 435925 mx 0000006100000061000000610010FFFF 436025 sp -------------------------------- 436126 a ccc_ 436226 mn 00000063000000630000006300000009 436326 mx 0000006300000063000000630010FFFF 436426 sp -------------------------------- 436527 a cch_ 436627 mn 00000063000000630000006800000009 436727 mx 0000006300000063000000680010FFFF 436827 sp -------------------------------- 436928 a aaa% 437028 mn 00000061000000610000006100000009 437128 mx 0000006100000061000000610010FFFF 437228 sp -------------------------------- 437329 a ccc% 437429 mn 00000063000000630000006300000009 437529 mx 0000006300000063000000630010FFFF 437629 sp -------------------------------- 437730 a cch% 437830 mn 00000063000000630000006800000009 437930 mx 0000006300000063000000680010FFFF 438030 sp -------------------------------- 438131 a aaaaaaaaaaaaaaaaaaaa 438231 mn 00000061000000610000006100000061 438331 mx 00000061000000610000006100000061 438431 sp -------------------------------- 438532 a caaaaaaaaaaaaaaaaaaa 438632 mn 00000063000000610000006100000061 438732 mx 00000063000000610000006100000061 438832 sp -------------------------------- 438933 a Х 439033 mn 00000425 439133 mx 00000425 439233 sp -------------------------------- 439334 a џ 439434 mn 0000045F 439534 mx 0000045F 439634 sp -------------------------------- 439735 a ┥ 439835 mn 00002525 439935 mx 00002525 440035 sp -------------------------------- 440136 a 彟 440236 mn 00005F5F 440336 mx 00005F5F 440436 sp -------------------------------- 4405DROP VIEW v1; 4406DROP TABLE t1; 4407# 4408# Start of 10.2 tests 4409# 4410# 4411# MDEV-10134 Add full support for DEFAULT 4412# 4413CREATE TABLE t1 ( 4414a VARCHAR(10), 4415mn VARCHAR(10) DEFAULT LIKE_RANGE_MIN(a,10), 4416mx VARCHAR(10) DEFAULT LIKE_RANGE_MAX(a,10) 4417); 4418SHOW CREATE TABLE t1; 4419Table Create Table 4420t1 CREATE TABLE `t1` ( 4421 `a` varchar(10) DEFAULT NULL, 4422 `mn` varchar(10) DEFAULT like_range_min(`a`,10), 4423 `mx` varchar(10) DEFAULT like_range_max(`a`,10) 4424) ENGINE=MyISAM DEFAULT CHARSET=latin1 4425INSERT INTO t1 (a) VALUES ('a'),('a_'),('a%'); 4426SELECT a, HEX(mn), HEX(mx) FROM t1; 4427a HEX(mn) HEX(mx) 4428a 61 61 4429a_ 6100 61FF 4430a% 61000000000000000000 61FFFFFFFFFFFFFFFFFF 4431DROP TABLE t1; 4432# 4433# MDEV-14350 Index use with collation utf8mb4_unicode_nopad_ci on LIKE pattern with wrong results 4434# 4435CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_nopad_ci); 4436INSERT INTO t1 VALUES ('111%'); 4437SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; 4438a HEX(LIKE_RANGE_MIN(a,200)) 4439111% 313131 4440DROP TABLE t1; 4441CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_nopad_ci); 4442INSERT INTO t1 VALUES ('111%'); 4443SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; 4444a HEX(LIKE_RANGE_MIN(a,200)) 4445111% 313131 4446DROP TABLE t1; 4447CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_nopad_ci); 4448INSERT INTO t1 VALUES ('111%'); 4449SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; 4450a HEX(LIKE_RANGE_MIN(a,200)) 4451111% 313131 4452DROP TABLE t1; 4453CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_nopad_ci); 4454INSERT INTO t1 VALUES ('111%'); 4455SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; 4456a HEX(LIKE_RANGE_MIN(a,200)) 4457111% 313131 4458DROP TABLE t1; 4459CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET ucs2 COLLATE ucs2_unicode_nopad_ci); 4460INSERT INTO t1 VALUES ('111%'); 4461SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; 4462a HEX(LIKE_RANGE_MIN(a,200)) 4463111% 003100310031 4464DROP TABLE t1; 4465CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf16 COLLATE utf16_unicode_nopad_ci); 4466INSERT INTO t1 VALUES ('111%'); 4467SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; 4468a HEX(LIKE_RANGE_MIN(a,200)) 4469111% 003100310031 4470DROP TABLE t1; 4471CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf32 COLLATE utf32_unicode_nopad_ci); 4472INSERT INTO t1 VALUES ('111%'); 4473SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; 4474a HEX(LIKE_RANGE_MIN(a,200)) 4475111% 000000310000003100000031 4476DROP TABLE t1; 4477# 4478# End of 10.2 tests 4479# 4480