SET NAMES utf8; DROP TABLE IF EXISTS t1; DROP VIEW IF EXISTS v1; CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a VARBINARY(32)); INSERT INTO t1 (a) VALUES (''),('_'),('%'),('\_'),('\%'),('\\'); INSERT INTO t1 (a) VALUES ('a'),('c'); INSERT INTO t1 (a) VALUES ('a_'),('c_'); INSERT INTO t1 (a) VALUES ('a%'),('c%'); INSERT INTO t1 (a) VALUES ('aa'),('cc'),('ch'); INSERT INTO t1 (a) VALUES ('aa_'),('cc_'),('ch_'); INSERT INTO t1 (a) VALUES ('aa%'),('cc%'),('ch%'); INSERT INTO t1 (a) VALUES ('aaa'),('ccc'),('cch'); INSERT INTO t1 (a) VALUES ('aaa_'),('ccc_'),('cch_'); INSERT INTO t1 (a) VALUES ('aaa%'),('ccc%'),('cch%'); INSERT INTO t1 (a) VALUES ('aaaaaaaaaaaaaaaaaaaa'); INSERT INTO t1 (a) VALUES ('caaaaaaaaaaaaaaaaaaa'); CREATE VIEW v1 AS SELECT id, 'a' AS name, a AS val FROM t1 UNION SELECT id, 'mn', HEX(LIKE_RANGE_MIN(a, 16)) AS min FROM t1 UNION SELECT id, 'mx', HEX(LIKE_RANGE_MAX(a, 16)) AS max FROM t1 UNION SELECT id, 'sp', REPEAT('-', 32) AS sep FROM t1 ORDER BY id, name; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 00 2 mx FF 2 sp -------------------------------- 3 a % 3 mn 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 6100 9 mx 61FF 9 sp -------------------------------- 10 a c_ 10 mn 6300 10 mx 63FF 10 sp -------------------------------- 11 a a% 11 mn 61 11 mx 61FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 63 12 mx 63FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 616100 16 mx 6161FF 16 sp -------------------------------- 17 a cc_ 17 mn 636300 17 mx 6363FF 17 sp -------------------------------- 18 a ch_ 18 mn 636800 18 mx 6368FF 18 sp -------------------------------- 19 a aa% 19 mn 6161 19 mx 6161FFFFFFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 6363 20 mx 6363FFFFFFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 6368 21 mx 6368FFFFFFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616100 25 mx 616161FF 25 sp -------------------------------- 26 a ccc_ 26 mn 63636300 26 mx 636363FF 26 sp -------------------------------- 27 a cch_ 27 mn 63636800 27 mx 636368FF 27 sp -------------------------------- 28 a aaa% 28 mn 616161 28 mx 616161FFFFFFFFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 636363 29 mx 636363FFFFFFFFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 636368 30 mx 636368FFFFFFFFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 61616161616161616161616161616161 31 mx 61616161616161616161616161616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 63616161616161616161616161616161 32 mx 63616161616161616161616161616161 32 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET latin1; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 00 2 mx FF 2 sp -------------------------------- 3 a % 3 mn 00000000000000000000000000000000 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 6100 9 mx 61FF 9 sp -------------------------------- 10 a c_ 10 mn 6300 10 mx 63FF 10 sp -------------------------------- 11 a a% 11 mn 61000000000000000000000000000000 11 mx 61FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 63000000000000000000000000000000 12 mx 63FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 616100 16 mx 6161FF 16 sp -------------------------------- 17 a cc_ 17 mn 636300 17 mx 6363FF 17 sp -------------------------------- 18 a ch_ 18 mn 636800 18 mx 6368FF 18 sp -------------------------------- 19 a aa% 19 mn 61610000000000000000000000000000 19 mx 6161FFFFFFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 63630000000000000000000000000000 20 mx 6363FFFFFFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 63680000000000000000000000000000 21 mx 6368FFFFFFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616100 25 mx 616161FF 25 sp -------------------------------- 26 a ccc_ 26 mn 63636300 26 mx 636363FF 26 sp -------------------------------- 27 a cch_ 27 mn 63636800 27 mx 636368FF 27 sp -------------------------------- 28 a aaa% 28 mn 61616100000000000000000000000000 28 mx 616161FFFFFFFFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 63636300000000000000000000000000 29 mx 636363FFFFFFFFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 63636800000000000000000000000000 30 mx 636368FFFFFFFFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 61616161616161616161616161616161 31 mx 61616161616161616161616161616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 63616161616161616161616161616161 32 mx 63616161616161616161616161616161 32 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8; INSERT INTO t1 (a) VALUES (_ucs2 0x0425),(_ucs2 0x045F); INSERT INTO t1 (a) VALUES (_ucs2 0x2525),(_ucs2 0x5F5F); SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 00000000000000000000000000000000 2 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2 sp -------------------------------- 3 a % 3 mn 00000000000000000000000000000000 3 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 61000000000000000000000000000000 9 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 9 sp -------------------------------- 10 a c_ 10 mn 63000000000000000000000000000000 10 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 10 sp -------------------------------- 11 a a% 11 mn 61000000000000000000000000000000 11 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 11 sp -------------------------------- 12 a c% 12 mn 63000000000000000000000000000000 12 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 61610000000000000000000000000000 16 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 16 sp -------------------------------- 17 a cc_ 17 mn 63630000000000000000000000000000 17 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 17 sp -------------------------------- 18 a ch_ 18 mn 63680000000000000000000000000000 18 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 18 sp -------------------------------- 19 a aa% 19 mn 61610000000000000000000000000000 19 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63630000000000000000000000000000 20 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 20 sp -------------------------------- 21 a ch% 21 mn 63680000000000000000000000000000 21 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616100000000000000000000000000 25 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 25 sp -------------------------------- 26 a ccc_ 26 mn 63636300000000000000000000000000 26 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 26 sp -------------------------------- 27 a cch_ 27 mn 63636800000000000000000000000000 27 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 27 sp -------------------------------- 28 a aaa% 28 mn 61616100000000000000000000000000 28 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 28 sp -------------------------------- 29 a ccc% 29 mn 63636300000000000000000000000000 29 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 29 sp -------------------------------- 30 a cch% 30 mn 63636800000000000000000000000000 30 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 6161616161 31 mx 6161616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 6361616161 32 mx 6361616161 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 09090909090909090909090909090909 2 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2 sp -------------------------------- 3 a % 3 mn 09090909090909090909090909090909 3 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 61090909090909090909090909090909 9 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 9 sp -------------------------------- 10 a c_ 10 mn 63090909090909090909090909090909 10 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 10 sp -------------------------------- 11 a a% 11 mn 61090909090909090909090909090909 11 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 11 sp -------------------------------- 12 a c% 12 mn 63090909090909090909090909090909 12 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 61610909090909090909090909090909 16 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 16 sp -------------------------------- 17 a cc_ 17 mn 63630909090909090909090909090909 17 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 17 sp -------------------------------- 18 a ch_ 18 mn 63680909090909090909090909090909 18 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 18 sp -------------------------------- 19 a aa% 19 mn 61610909090909090909090909090909 19 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63630909090909090909090909090909 20 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 20 sp -------------------------------- 21 a ch% 21 mn 63680909090909090909090909090909 21 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616109090909090909090909090909 25 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 25 sp -------------------------------- 26 a ccc_ 26 mn 63636309090909090909090909090909 26 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 26 sp -------------------------------- 27 a cch_ 27 mn 63636809090909090909090909090909 27 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 27 sp -------------------------------- 28 a aaa% 28 mn 61616109090909090909090909090909 28 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 28 sp -------------------------------- 29 a ccc% 29 mn 63636309090909090909090909090909 29 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 29 sp -------------------------------- 30 a cch% 30 mn 63636809090909090909090909090909 30 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 6161616161 31 mx 6161616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 6361616161 32 mx 6361616161 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_czech_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 09090909090909090909090909090909 2 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2 sp -------------------------------- 3 a % 3 mn 09090909090909090909090909090909 3 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 61090909090909090909090909090909 9 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 9 sp -------------------------------- 10 a c_ 10 mn 09090909090909090909090909090909 10 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 10 sp -------------------------------- 11 a a% 11 mn 61090909090909090909090909090909 11 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 11 sp -------------------------------- 12 a c% 12 mn 09090909090909090909090909090909 12 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 61610909090909090909090909090909 16 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 16 sp -------------------------------- 17 a cc_ 17 mn 63090909090909090909090909090909 17 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 17 sp -------------------------------- 18 a ch_ 18 mn 63680909090909090909090909090909 18 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 18 sp -------------------------------- 19 a aa% 19 mn 61610909090909090909090909090909 19 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63090909090909090909090909090909 20 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 20 sp -------------------------------- 21 a ch% 21 mn 63680909090909090909090909090909 21 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616109090909090909090909090909 25 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 25 sp -------------------------------- 26 a ccc_ 26 mn 63630909090909090909090909090909 26 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 26 sp -------------------------------- 27 a cch_ 27 mn 63636809090909090909090909090909 27 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 27 sp -------------------------------- 28 a aaa% 28 mn 61616109090909090909090909090909 28 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 28 sp -------------------------------- 29 a ccc% 29 mn 63630909090909090909090909090909 29 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 29 sp -------------------------------- 30 a cch% 30 mn 63636809090909090909090909090909 30 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 6161616161 31 mx 6161616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 6361616161 32 mx 6361616161 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_danish_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 09090909090909090909090909090909 2 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2 sp -------------------------------- 3 a % 3 mn 09090909090909090909090909090909 3 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 09090909090909090909090909090909 9 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 9 sp -------------------------------- 10 a c_ 10 mn 63090909090909090909090909090909 10 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 10 sp -------------------------------- 11 a a% 11 mn 09090909090909090909090909090909 11 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 11 sp -------------------------------- 12 a c% 12 mn 63090909090909090909090909090909 12 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 61610909090909090909090909090909 16 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 16 sp -------------------------------- 17 a cc_ 17 mn 63630909090909090909090909090909 17 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 17 sp -------------------------------- 18 a ch_ 18 mn 63680909090909090909090909090909 18 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 18 sp -------------------------------- 19 a aa% 19 mn 61610909090909090909090909090909 19 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63630909090909090909090909090909 20 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 20 sp -------------------------------- 21 a ch% 21 mn 63680909090909090909090909090909 21 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61610909090909090909090909090909 25 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 25 sp -------------------------------- 26 a ccc_ 26 mn 63636309090909090909090909090909 26 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 26 sp -------------------------------- 27 a cch_ 27 mn 63636809090909090909090909090909 27 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 27 sp -------------------------------- 28 a aaa% 28 mn 61610909090909090909090909090909 28 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 28 sp -------------------------------- 29 a ccc% 29 mn 63636309090909090909090909090909 29 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 29 sp -------------------------------- 30 a cch% 30 mn 63636809090909090909090909090909 30 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 61616161090909090909090909090909 31 mx 61616161EFBFBFEFBFBFEFBFBFEFBFBF 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 6361616161 32 mx 6361616161 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_thai_520_w2; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 09 2 mx EFBFBF 2 sp -------------------------------- 3 a % 3 mn 09090909090909090909090909090909 3 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 6109 9 mx 61EFBFBF 9 sp -------------------------------- 10 a c_ 10 mn 6309 10 mx 63EFBFBF 10 sp -------------------------------- 11 a a% 11 mn 61090909090909090909090909090909 11 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 11 sp -------------------------------- 12 a c% 12 mn 63090909090909090909090909090909 12 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 616109 16 mx 6161EFBFBF 16 sp -------------------------------- 17 a cc_ 17 mn 636309 17 mx 6363EFBFBF 17 sp -------------------------------- 18 a ch_ 18 mn 636809 18 mx 6368EFBFBF 18 sp -------------------------------- 19 a aa% 19 mn 61610909090909090909090909090909 19 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63630909090909090909090909090909 20 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 20 sp -------------------------------- 21 a ch% 21 mn 63680909090909090909090909090909 21 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616109 25 mx 616161EFBFBF 25 sp -------------------------------- 26 a ccc_ 26 mn 63636309 26 mx 636363EFBFBF 26 sp -------------------------------- 27 a cch_ 27 mn 63636809 27 mx 636368EFBFBF 27 sp -------------------------------- 28 a aaa% 28 mn 61616109090909090909090909090909 28 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 28 sp -------------------------------- 29 a ccc% 29 mn 63636309090909090909090909090909 29 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 29 sp -------------------------------- 30 a cch% 30 mn 63636809090909090909090909090909 30 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 6161616161 31 mx 6161616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 6361616161 32 mx 6361616161 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 00000000000000000000000000000000 2 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2 sp -------------------------------- 3 a % 3 mn 00000000000000000000000000000000 3 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 61000000000000000000000000000000 9 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 9 sp -------------------------------- 10 a c_ 10 mn 63000000000000000000000000000000 10 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 10 sp -------------------------------- 11 a a% 11 mn 61000000000000000000000000000000 11 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 11 sp -------------------------------- 12 a c% 12 mn 63000000000000000000000000000000 12 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 61610000000000000000000000000000 16 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 16 sp -------------------------------- 17 a cc_ 17 mn 63630000000000000000000000000000 17 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 17 sp -------------------------------- 18 a ch_ 18 mn 63680000000000000000000000000000 18 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 18 sp -------------------------------- 19 a aa% 19 mn 61610000000000000000000000000000 19 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63630000000000000000000000000000 20 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 20 sp -------------------------------- 21 a ch% 21 mn 63680000000000000000000000000000 21 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616100000000000000000000000000 25 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 25 sp -------------------------------- 26 a ccc_ 26 mn 63636300000000000000000000000000 26 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 26 sp -------------------------------- 27 a cch_ 27 mn 63636800000000000000000000000000 27 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 27 sp -------------------------------- 28 a aaa% 28 mn 61616100000000000000000000000000 28 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 28 sp -------------------------------- 29 a ccc% 29 mn 63636300000000000000000000000000 29 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 29 sp -------------------------------- 30 a cch% 30 mn 63636800000000000000000000000000 30 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 61616161 31 mx 61616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 63616161 32 mx 63616161 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 09090909090909090909090909090909 2 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2 sp -------------------------------- 3 a % 3 mn 09090909090909090909090909090909 3 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 61090909090909090909090909090909 9 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 9 sp -------------------------------- 10 a c_ 10 mn 63090909090909090909090909090909 10 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 10 sp -------------------------------- 11 a a% 11 mn 61090909090909090909090909090909 11 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 11 sp -------------------------------- 12 a c% 12 mn 63090909090909090909090909090909 12 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 61610909090909090909090909090909 16 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 16 sp -------------------------------- 17 a cc_ 17 mn 63630909090909090909090909090909 17 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 17 sp -------------------------------- 18 a ch_ 18 mn 63680909090909090909090909090909 18 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 18 sp -------------------------------- 19 a aa% 19 mn 61610909090909090909090909090909 19 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63630909090909090909090909090909 20 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 20 sp -------------------------------- 21 a ch% 21 mn 63680909090909090909090909090909 21 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616109090909090909090909090909 25 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 25 sp -------------------------------- 26 a ccc_ 26 mn 63636309090909090909090909090909 26 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 26 sp -------------------------------- 27 a cch_ 27 mn 63636809090909090909090909090909 27 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 27 sp -------------------------------- 28 a aaa% 28 mn 61616109090909090909090909090909 28 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 28 sp -------------------------------- 29 a ccc% 29 mn 63636309090909090909090909090909 29 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 29 sp -------------------------------- 30 a cch% 30 mn 63636809090909090909090909090909 30 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 61616161 31 mx 61616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 63616161 32 mx 63616161 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 09090909090909090909090909090909 2 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2 sp -------------------------------- 3 a % 3 mn 09090909090909090909090909090909 3 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 61090909090909090909090909090909 9 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 9 sp -------------------------------- 10 a c_ 10 mn 09090909090909090909090909090909 10 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 10 sp -------------------------------- 11 a a% 11 mn 61090909090909090909090909090909 11 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 11 sp -------------------------------- 12 a c% 12 mn 09090909090909090909090909090909 12 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 61610909090909090909090909090909 16 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 16 sp -------------------------------- 17 a cc_ 17 mn 63090909090909090909090909090909 17 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 17 sp -------------------------------- 18 a ch_ 18 mn 63680909090909090909090909090909 18 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 18 sp -------------------------------- 19 a aa% 19 mn 61610909090909090909090909090909 19 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63090909090909090909090909090909 20 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 20 sp -------------------------------- 21 a ch% 21 mn 63680909090909090909090909090909 21 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616109090909090909090909090909 25 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 25 sp -------------------------------- 26 a ccc_ 26 mn 63630909090909090909090909090909 26 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 26 sp -------------------------------- 27 a cch_ 27 mn 63636809090909090909090909090909 27 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 27 sp -------------------------------- 28 a aaa% 28 mn 61616109090909090909090909090909 28 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 28 sp -------------------------------- 29 a ccc% 29 mn 63630909090909090909090909090909 29 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 29 sp -------------------------------- 30 a cch% 30 mn 63636809090909090909090909090909 30 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 61616161 31 mx 61616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 63616161 32 mx 63616161 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 09090909090909090909090909090909 2 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 2 sp -------------------------------- 3 a % 3 mn 09090909090909090909090909090909 3 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 09090909090909090909090909090909 9 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 9 sp -------------------------------- 10 a c_ 10 mn 63090909090909090909090909090909 10 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 10 sp -------------------------------- 11 a a% 11 mn 09090909090909090909090909090909 11 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 11 sp -------------------------------- 12 a c% 12 mn 63090909090909090909090909090909 12 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 61610909090909090909090909090909 16 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 16 sp -------------------------------- 17 a cc_ 17 mn 63630909090909090909090909090909 17 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 17 sp -------------------------------- 18 a ch_ 18 mn 63680909090909090909090909090909 18 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 18 sp -------------------------------- 19 a aa% 19 mn 61610909090909090909090909090909 19 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63630909090909090909090909090909 20 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 20 sp -------------------------------- 21 a ch% 21 mn 63680909090909090909090909090909 21 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61610909090909090909090909090909 25 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 25 sp -------------------------------- 26 a ccc_ 26 mn 63636309090909090909090909090909 26 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 26 sp -------------------------------- 27 a cch_ 27 mn 63636809090909090909090909090909 27 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 27 sp -------------------------------- 28 a aaa% 28 mn 61610909090909090909090909090909 28 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 28 sp -------------------------------- 29 a ccc% 29 mn 63636309090909090909090909090909 29 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 29 sp -------------------------------- 30 a cch% 30 mn 63636809090909090909090909090909 30 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 61616161 31 mx 61616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 63616109090909090909090909090909 32 mx 636161EFBFBFEFBFBFEFBFBFEFBFBF20 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_thai_520_w2; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 09 2 mx EFBFBF 2 sp -------------------------------- 3 a % 3 mn 09090909090909090909090909090909 3 mx EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF20 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 6109 9 mx 61EFBFBF 9 sp -------------------------------- 10 a c_ 10 mn 6309 10 mx 63EFBFBF 10 sp -------------------------------- 11 a a% 11 mn 61090909090909090909090909090909 11 mx 61EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 11 sp -------------------------------- 12 a c% 12 mn 63090909090909090909090909090909 12 mx 63EFBFBFEFBFBFEFBFBFEFBFBFEFBFBF 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 616109 16 mx 6161EFBFBF 16 sp -------------------------------- 17 a cc_ 17 mn 636309 17 mx 6363EFBFBF 17 sp -------------------------------- 18 a ch_ 18 mn 636809 18 mx 6368EFBFBF 18 sp -------------------------------- 19 a aa% 19 mn 61610909090909090909090909090909 19 mx 6161EFBFBFEFBFBFEFBFBFEFBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63630909090909090909090909090909 20 mx 6363EFBFBFEFBFBFEFBFBFEFBFBF2020 20 sp -------------------------------- 21 a ch% 21 mn 63680909090909090909090909090909 21 mx 6368EFBFBFEFBFBFEFBFBFEFBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616109 25 mx 616161EFBFBF 25 sp -------------------------------- 26 a ccc_ 26 mn 63636309 26 mx 636363EFBFBF 26 sp -------------------------------- 27 a cch_ 27 mn 63636809 27 mx 636368EFBFBF 27 sp -------------------------------- 28 a aaa% 28 mn 61616109090909090909090909090909 28 mx 616161EFBFBFEFBFBFEFBFBFEFBFBF20 28 sp -------------------------------- 29 a ccc% 29 mn 63636309090909090909090909090909 29 mx 636363EFBFBFEFBFBFEFBFBFEFBFBF20 29 sp -------------------------------- 30 a cch% 30 mn 63636809090909090909090909090909 30 mx 636368EFBFBFEFBFBFEFBFBFEFBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 61616161 31 mx 61616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 63616161 32 mx 63616161 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 09090909090909090909090909090909 2 mx F48FBFBFF48FBFBFF48FBFBFF48FBFBF 2 sp -------------------------------- 3 a % 3 mn 09090909090909090909090909090909 3 mx F48FBFBFF48FBFBFF48FBFBFF48FBFBF 3 sp -------------------------------- 4 a \_ 4 mn 5F 4 mx 5F 4 sp -------------------------------- 5 a \% 5 mn 25 5 mx 25 5 sp -------------------------------- 6 a \ 6 mn 5C 6 mx 5C 6 sp -------------------------------- 7 a a 7 mn 61 7 mx 61 7 sp -------------------------------- 8 a c 8 mn 63 8 mx 63 8 sp -------------------------------- 9 a a_ 9 mn 61090909090909090909090909090909 9 mx 61F48FBFBFF48FBFBFF48FBFBF202020 9 sp -------------------------------- 10 a c_ 10 mn 63090909090909090909090909090909 10 mx 63F48FBFBFF48FBFBFF48FBFBF202020 10 sp -------------------------------- 11 a a% 11 mn 61090909090909090909090909090909 11 mx 61F48FBFBFF48FBFBFF48FBFBF202020 11 sp -------------------------------- 12 a c% 12 mn 63090909090909090909090909090909 12 mx 63F48FBFBFF48FBFBFF48FBFBF202020 12 sp -------------------------------- 13 a aa 13 mn 6161 13 mx 6161 13 sp -------------------------------- 14 a cc 14 mn 6363 14 mx 6363 14 sp -------------------------------- 15 a ch 15 mn 6368 15 mx 6368 15 sp -------------------------------- 16 a aa_ 16 mn 61610909090909090909090909090909 16 mx 6161F48FBFBFF48FBFBFF48FBFBF2020 16 sp -------------------------------- 17 a cc_ 17 mn 63630909090909090909090909090909 17 mx 6363F48FBFBFF48FBFBFF48FBFBF2020 17 sp -------------------------------- 18 a ch_ 18 mn 63680909090909090909090909090909 18 mx 6368F48FBFBFF48FBFBFF48FBFBF2020 18 sp -------------------------------- 19 a aa% 19 mn 61610909090909090909090909090909 19 mx 6161F48FBFBFF48FBFBFF48FBFBF2020 19 sp -------------------------------- 20 a cc% 20 mn 63630909090909090909090909090909 20 mx 6363F48FBFBFF48FBFBFF48FBFBF2020 20 sp -------------------------------- 21 a ch% 21 mn 63680909090909090909090909090909 21 mx 6368F48FBFBFF48FBFBFF48FBFBF2020 21 sp -------------------------------- 22 a aaa 22 mn 616161 22 mx 616161 22 sp -------------------------------- 23 a ccc 23 mn 636363 23 mx 636363 23 sp -------------------------------- 24 a cch 24 mn 636368 24 mx 636368 24 sp -------------------------------- 25 a aaa_ 25 mn 61616109090909090909090909090909 25 mx 616161F48FBFBFF48FBFBFF48FBFBF20 25 sp -------------------------------- 26 a ccc_ 26 mn 63636309090909090909090909090909 26 mx 636363F48FBFBFF48FBFBFF48FBFBF20 26 sp -------------------------------- 27 a cch_ 27 mn 63636809090909090909090909090909 27 mx 636368F48FBFBFF48FBFBFF48FBFBF20 27 sp -------------------------------- 28 a aaa% 28 mn 61616109090909090909090909090909 28 mx 616161F48FBFBFF48FBFBFF48FBFBF20 28 sp -------------------------------- 29 a ccc% 29 mn 63636309090909090909090909090909 29 mx 636363F48FBFBFF48FBFBFF48FBFBF20 29 sp -------------------------------- 30 a cch% 30 mn 63636809090909090909090909090909 30 mx 636368F48FBFBFF48FBFBFF48FBFBF20 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 61616161 31 mx 61616161 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 63616161 32 mx 63616161 32 sp -------------------------------- 33 a Х 33 mn D0A5 33 mx D0A5 33 sp -------------------------------- 34 a џ 34 mn D19F 34 mx D19F 34 sp -------------------------------- 35 a ┥ 35 mn E294A5 35 mx E294A5 35 sp -------------------------------- 36 a 彟 36 mn E5BD9F 36 mx E5BD9F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0000 2 mx FFFF 2 sp -------------------------------- 3 a % 3 mn 00000000000000000000000000000000 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00610000 9 mx 0061FFFF 9 sp -------------------------------- 10 a c_ 10 mn 00630000 10 mx 0063FFFF 10 sp -------------------------------- 11 a a% 11 mn 00610000000000000000000000000000 11 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 00630000000000000000000000000000 12 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610000 16 mx 00610061FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 006300630000 17 mx 00630063FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680000 18 mx 00630068FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000000000000000000000000 19 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630063000000000000000000000000 20 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000000000000000000000000 21 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 0061006100610000 25 mx 006100610061FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 0063006300630000 26 mx 006300630063FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680000 27 mx 006300630068FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061006100000000000000000000 28 mx 006100610061FFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00630063006300000000000000000000 29 mx 006300630063FFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800000000000000000000 30 mx 006300630068FFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00610061006100610061006100610061 31 mx 00610061006100610061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00630061006100610061006100610061 32 mx 00630061006100610061006100610061 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_unicode_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0009 2 mx FFFF 2 sp -------------------------------- 3 a % 3 mn 00090009000900090009000900090009 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00610009 9 mx 0061FFFF 9 sp -------------------------------- 10 a c_ 10 mn 00630009 10 mx 0063FFFF 10 sp -------------------------------- 11 a a% 11 mn 00610009000900090009000900090009 11 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 00630009000900090009000900090009 12 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610009 16 mx 00610061FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 006300630009 17 mx 00630063FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680009 18 mx 00630068FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000900090009000900090009 19 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630063000900090009000900090009 20 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000900090009000900090009 21 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 0061006100610009 25 mx 006100610061FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 0063006300630009 26 mx 006300630063FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680009 27 mx 006300630068FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061006100090009000900090009 28 mx 006100610061FFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00630063006300090009000900090009 29 mx 006300630063FFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800090009000900090009 30 mx 006300630068FFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00610061006100610061006100610061 31 mx 00610061006100610061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00630061006100610061006100610061 32 mx 00630061006100610061006100610061 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_czech_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0009 2 mx FFFF 2 sp -------------------------------- 3 a % 3 mn 00090009000900090009000900090009 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00610009 9 mx 0061FFFF 9 sp -------------------------------- 10 a c_ 10 mn 00090009000900090009000900090009 10 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 10 sp -------------------------------- 11 a a% 11 mn 00610009000900090009000900090009 11 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 00090009000900090009000900090009 12 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610009 16 mx 00610061FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 00630009000900090009000900090009 17 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680009 18 mx 00630068FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000900090009000900090009 19 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630009000900090009000900090009 20 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000900090009000900090009 21 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 0061006100610009 25 mx 006100610061FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 00630063000900090009000900090009 26 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680009 27 mx 006300630068FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061006100090009000900090009 28 mx 006100610061FFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00630063000900090009000900090009 29 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800090009000900090009 30 mx 006300630068FFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00610061006100610061006100610061 31 mx 00610061006100610061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00630061006100610061006100610061 32 mx 00630061006100610061006100610061 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_danish_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0009 2 mx FFFF 2 sp -------------------------------- 3 a % 3 mn 00090009000900090009000900090009 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00090009000900090009000900090009 9 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 9 sp -------------------------------- 10 a c_ 10 mn 00630009 10 mx 0063FFFF 10 sp -------------------------------- 11 a a% 11 mn 00090009000900090009000900090009 11 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 00630009000900090009000900090009 12 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610009 16 mx 00610061FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 006300630009 17 mx 00630063FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680009 18 mx 00630068FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000900090009000900090009 19 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630063000900090009000900090009 20 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000900090009000900090009 21 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 00610061000900090009000900090009 25 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 0063006300630009 26 mx 006300630063FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680009 27 mx 006300630068FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061000900090009000900090009 28 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00630063006300090009000900090009 29 mx 006300630063FFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800090009000900090009 30 mx 006300630068FFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00610061006100610061006100610061 31 mx 00610061006100610061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00630061006100610061006100610009 32 mx 0063006100610061006100610061FFFF 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET ucs2 COLLATE ucs2_thai_520_w2; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0009 2 mx FFFF 2 sp -------------------------------- 3 a % 3 mn 00090009000900090009000900090009 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00610009 9 mx 0061FFFF 9 sp -------------------------------- 10 a c_ 10 mn 00630009 10 mx 0063FFFF 10 sp -------------------------------- 11 a a% 11 mn 00610009000900090009000900090009 11 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 00630009000900090009000900090009 12 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610009 16 mx 00610061FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 006300630009 17 mx 00630063FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680009 18 mx 00630068FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000900090009000900090009 19 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630063000900090009000900090009 20 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000900090009000900090009 21 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 0061006100610009 25 mx 006100610061FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 0063006300630009 26 mx 006300630063FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680009 27 mx 006300630068FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061006100090009000900090009 28 mx 006100610061FFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00630063006300090009000900090009 29 mx 006300630063FFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800090009000900090009 30 mx 006300630068FFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00610061006100610061006100610061 31 mx 00610061006100610061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00630061006100610061006100610061 32 mx 00630061006100610061006100610061 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0000 2 mx FFFF 2 sp -------------------------------- 3 a % 3 mn 00000000000000000000000000000000 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00610000 9 mx 0061FFFF 9 sp -------------------------------- 10 a c_ 10 mn 00630000 10 mx 0063FFFF 10 sp -------------------------------- 11 a a% 11 mn 00610000000000000000000000000000 11 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 00630000000000000000000000000000 12 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610000 16 mx 00610061FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 006300630000 17 mx 00630063FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680000 18 mx 00630068FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000000000000000000000000 19 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630063000000000000000000000000 20 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000000000000000000000000 21 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 0061006100610000 25 mx 006100610061FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 0063006300630000 26 mx 006300630063FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680000 27 mx 006300630068FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061006100000000000000000000 28 mx 006100610061FFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00630063006300000000000000000000 29 mx 006300630063FFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800000000000000000000 30 mx 006300630068FFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 0061006100610061 31 mx 0061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 0063006100610061 32 mx 0063006100610061 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_unicode_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0009 2 mx FFFF 2 sp -------------------------------- 3 a % 3 mn 00090009000900090009000900090009 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00610009 9 mx 0061FFFF 9 sp -------------------------------- 10 a c_ 10 mn 00630009 10 mx 0063FFFF 10 sp -------------------------------- 11 a a% 11 mn 00610009000900090009000900090009 11 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 00630009000900090009000900090009 12 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610009 16 mx 00610061FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 006300630009 17 mx 00630063FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680009 18 mx 00630068FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000900090009000900090009 19 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630063000900090009000900090009 20 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000900090009000900090009 21 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 0061006100610009 25 mx 006100610061FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 0063006300630009 26 mx 006300630063FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680009 27 mx 006300630068FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061006100090009000900090009 28 mx 006100610061FFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00630063006300090009000900090009 29 mx 006300630063FFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800090009000900090009 30 mx 006300630068FFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 0061006100610061 31 mx 0061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 0063006100610061 32 mx 0063006100610061 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_czech_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0009 2 mx FFFF 2 sp -------------------------------- 3 a % 3 mn 00090009000900090009000900090009 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00610009 9 mx 0061FFFF 9 sp -------------------------------- 10 a c_ 10 mn 00090009000900090009000900090009 10 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 10 sp -------------------------------- 11 a a% 11 mn 00610009000900090009000900090009 11 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 00090009000900090009000900090009 12 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610009 16 mx 00610061FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 00630009000900090009000900090009 17 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680009 18 mx 00630068FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000900090009000900090009 19 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630009000900090009000900090009 20 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000900090009000900090009 21 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 0061006100610009 25 mx 006100610061FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 00630063000900090009000900090009 26 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680009 27 mx 006300630068FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061006100090009000900090009 28 mx 006100610061FFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00630063000900090009000900090009 29 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800090009000900090009 30 mx 006300630068FFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 0061006100610061 31 mx 0061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 0063006100610061 32 mx 0063006100610061 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_danish_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0009 2 mx FFFF 2 sp -------------------------------- 3 a % 3 mn 00090009000900090009000900090009 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00090009000900090009000900090009 9 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 9 sp -------------------------------- 10 a c_ 10 mn 00630009 10 mx 0063FFFF 10 sp -------------------------------- 11 a a% 11 mn 00090009000900090009000900090009 11 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 00630009000900090009000900090009 12 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610009 16 mx 00610061FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 006300630009 17 mx 00630063FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680009 18 mx 00630068FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000900090009000900090009 19 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630063000900090009000900090009 20 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000900090009000900090009 21 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 00610061000900090009000900090009 25 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 0063006300630009 26 mx 006300630063FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680009 27 mx 006300630068FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061000900090009000900090009 28 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00630063006300090009000900090009 29 mx 006300630063FFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800090009000900090009 30 mx 006300630068FFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 0061006100610061 31 mx 0061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00630061006100090009000900090009 32 mx 006300610061FFFFFFFFFFFFFFFFFFFF 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_thai_520_w2; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0009 2 mx FFFF 2 sp -------------------------------- 3 a % 3 mn 00090009000900090009000900090009 3 mx FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00610009 9 mx 0061FFFF 9 sp -------------------------------- 10 a c_ 10 mn 00630009 10 mx 0063FFFF 10 sp -------------------------------- 11 a a% 11 mn 00610009000900090009000900090009 11 mx 0061FFFFFFFFFFFFFFFFFFFFFFFFFFFF 11 sp -------------------------------- 12 a c% 12 mn 00630009000900090009000900090009 12 mx 0063FFFFFFFFFFFFFFFFFFFFFFFFFFFF 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610009 16 mx 00610061FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 006300630009 17 mx 00630063FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680009 18 mx 00630068FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000900090009000900090009 19 mx 00610061FFFFFFFFFFFFFFFFFFFFFFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630063000900090009000900090009 20 mx 00630063FFFFFFFFFFFFFFFFFFFFFFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000900090009000900090009 21 mx 00630068FFFFFFFFFFFFFFFFFFFFFFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 0061006100610009 25 mx 006100610061FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 0063006300630009 26 mx 006300630063FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680009 27 mx 006300630068FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061006100090009000900090009 28 mx 006100610061FFFFFFFFFFFFFFFFFFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00630063006300090009000900090009 29 mx 006300630063FFFFFFFFFFFFFFFFFFFF 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800090009000900090009 30 mx 006300630068FFFFFFFFFFFFFFFFFFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 0061006100610061 31 mx 0061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 0063006100610061 32 mx 0063006100610061 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf16 COLLATE utf16_unicode_520_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 0009 2 mx DBFFDFFF 2 sp -------------------------------- 3 a % 3 mn 00090009000900090009000900090009 3 mx DBFFDFFFDBFFDFFFDBFFDFFFDBFFDFFF 3 sp -------------------------------- 4 a \_ 4 mn 005F 4 mx 005F 4 sp -------------------------------- 5 a \% 5 mn 0025 5 mx 0025 5 sp -------------------------------- 6 a \ 6 mn 005C 6 mx 005C 6 sp -------------------------------- 7 a a 7 mn 0061 7 mx 0061 7 sp -------------------------------- 8 a c 8 mn 0063 8 mx 0063 8 sp -------------------------------- 9 a a_ 9 mn 00610009 9 mx 0061DBFFDFFF 9 sp -------------------------------- 10 a c_ 10 mn 00630009 10 mx 0063DBFFDFFF 10 sp -------------------------------- 11 a a% 11 mn 00610009000900090009000900090009 11 mx 0061DBFFDFFFDBFFDFFFDBFFDFFF0000 11 sp -------------------------------- 12 a c% 12 mn 00630009000900090009000900090009 12 mx 0063DBFFDFFFDBFFDFFFDBFFDFFF0000 12 sp -------------------------------- 13 a aa 13 mn 00610061 13 mx 00610061 13 sp -------------------------------- 14 a cc 14 mn 00630063 14 mx 00630063 14 sp -------------------------------- 15 a ch 15 mn 00630068 15 mx 00630068 15 sp -------------------------------- 16 a aa_ 16 mn 006100610009 16 mx 00610061DBFFDFFF 16 sp -------------------------------- 17 a cc_ 17 mn 006300630009 17 mx 00630063DBFFDFFF 17 sp -------------------------------- 18 a ch_ 18 mn 006300680009 18 mx 00630068DBFFDFFF 18 sp -------------------------------- 19 a aa% 19 mn 00610061000900090009000900090009 19 mx 00610061DBFFDFFFDBFFDFFFDBFFDFFF 19 sp -------------------------------- 20 a cc% 20 mn 00630063000900090009000900090009 20 mx 00630063DBFFDFFFDBFFDFFFDBFFDFFF 20 sp -------------------------------- 21 a ch% 21 mn 00630068000900090009000900090009 21 mx 00630068DBFFDFFFDBFFDFFFDBFFDFFF 21 sp -------------------------------- 22 a aaa 22 mn 006100610061 22 mx 006100610061 22 sp -------------------------------- 23 a ccc 23 mn 006300630063 23 mx 006300630063 23 sp -------------------------------- 24 a cch 24 mn 006300630068 24 mx 006300630068 24 sp -------------------------------- 25 a aaa_ 25 mn 0061006100610009 25 mx 006100610061DBFFDFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 0063006300630009 26 mx 006300630063DBFFDFFF 26 sp -------------------------------- 27 a cch_ 27 mn 0063006300680009 27 mx 006300630068DBFFDFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00610061006100090009000900090009 28 mx 006100610061DBFFDFFFDBFFDFFF0000 28 sp -------------------------------- 29 a ccc% 29 mn 00630063006300090009000900090009 29 mx 006300630063DBFFDFFFDBFFDFFF0000 29 sp -------------------------------- 30 a cch% 30 mn 00630063006800090009000900090009 30 mx 006300630068DBFFDFFFDBFFDFFF0000 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 0061006100610061 31 mx 0061006100610061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 0063006100610061 32 mx 0063006100610061 32 sp -------------------------------- 33 a Х 33 mn 0425 33 mx 0425 33 sp -------------------------------- 34 a џ 34 mn 045F 34 mx 045F 34 sp -------------------------------- 35 a ┥ 35 mn 2525 35 mx 2525 35 sp -------------------------------- 36 a 彟 36 mn 5F5F 36 mx 5F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 00000000 2 mx 0000FFFF 2 sp -------------------------------- 3 a % 3 mn 00000000000000000000000000000000 3 mx 0000FFFF0000FFFF0000FFFF0000FFFF 3 sp -------------------------------- 4 a \_ 4 mn 0000005F 4 mx 0000005F 4 sp -------------------------------- 5 a \% 5 mn 00000025 5 mx 00000025 5 sp -------------------------------- 6 a \ 6 mn 0000005C 6 mx 0000005C 6 sp -------------------------------- 7 a a 7 mn 00000061 7 mx 00000061 7 sp -------------------------------- 8 a c 8 mn 00000063 8 mx 00000063 8 sp -------------------------------- 9 a a_ 9 mn 0000006100000000 9 mx 000000610000FFFF 9 sp -------------------------------- 10 a c_ 10 mn 0000006300000000 10 mx 000000630000FFFF 10 sp -------------------------------- 11 a a% 11 mn 00000061000000000000000000000000 11 mx 000000610000FFFF0000FFFF0000FFFF 11 sp -------------------------------- 12 a c% 12 mn 00000063000000000000000000000000 12 mx 000000630000FFFF0000FFFF0000FFFF 12 sp -------------------------------- 13 a aa 13 mn 0000006100000061 13 mx 0000006100000061 13 sp -------------------------------- 14 a cc 14 mn 0000006300000063 14 mx 0000006300000063 14 sp -------------------------------- 15 a ch 15 mn 0000006300000068 15 mx 0000006300000068 15 sp -------------------------------- 16 a aa_ 16 mn 000000610000006100000000 16 mx 00000061000000610000FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 000000630000006300000000 17 mx 00000063000000630000FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 000000630000006800000000 18 mx 00000063000000680000FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00000061000000610000000000000000 19 mx 00000061000000610000FFFF0000FFFF 19 sp -------------------------------- 20 a cc% 20 mn 00000063000000630000000000000000 20 mx 00000063000000630000FFFF0000FFFF 20 sp -------------------------------- 21 a ch% 21 mn 00000063000000680000000000000000 21 mx 00000063000000680000FFFF0000FFFF 21 sp -------------------------------- 22 a aaa 22 mn 000000610000006100000061 22 mx 000000610000006100000061 22 sp -------------------------------- 23 a ccc 23 mn 000000630000006300000063 23 mx 000000630000006300000063 23 sp -------------------------------- 24 a cch 24 mn 000000630000006300000068 24 mx 000000630000006300000068 24 sp -------------------------------- 25 a aaa_ 25 mn 00000061000000610000006100000000 25 mx 0000006100000061000000610000FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 00000063000000630000006300000000 26 mx 0000006300000063000000630000FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 00000063000000630000006800000000 27 mx 0000006300000063000000680000FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00000061000000610000006100000000 28 mx 0000006100000061000000610000FFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00000063000000630000006300000000 29 mx 0000006300000063000000630000FFFF 29 sp -------------------------------- 30 a cch% 30 mn 00000063000000630000006800000000 30 mx 0000006300000063000000680000FFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00000061000000610000006100000061 31 mx 00000061000000610000006100000061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00000063000000610000006100000061 32 mx 00000063000000610000006100000061 32 sp -------------------------------- 33 a Х 33 mn 00000425 33 mx 00000425 33 sp -------------------------------- 34 a џ 34 mn 0000045F 34 mx 0000045F 34 sp -------------------------------- 35 a ┥ 35 mn 00002525 35 mx 00002525 35 sp -------------------------------- 36 a 彟 36 mn 00005F5F 36 mx 00005F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_unicode_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 00000009 2 mx 0000FFFF 2 sp -------------------------------- 3 a % 3 mn 00000009000000090000000900000009 3 mx 0000FFFF0000FFFF0000FFFF0000FFFF 3 sp -------------------------------- 4 a \_ 4 mn 0000005F 4 mx 0000005F 4 sp -------------------------------- 5 a \% 5 mn 00000025 5 mx 00000025 5 sp -------------------------------- 6 a \ 6 mn 0000005C 6 mx 0000005C 6 sp -------------------------------- 7 a a 7 mn 00000061 7 mx 00000061 7 sp -------------------------------- 8 a c 8 mn 00000063 8 mx 00000063 8 sp -------------------------------- 9 a a_ 9 mn 0000006100000009 9 mx 000000610000FFFF 9 sp -------------------------------- 10 a c_ 10 mn 0000006300000009 10 mx 000000630000FFFF 10 sp -------------------------------- 11 a a% 11 mn 00000061000000090000000900000009 11 mx 000000610000FFFF0000FFFF0000FFFF 11 sp -------------------------------- 12 a c% 12 mn 00000063000000090000000900000009 12 mx 000000630000FFFF0000FFFF0000FFFF 12 sp -------------------------------- 13 a aa 13 mn 0000006100000061 13 mx 0000006100000061 13 sp -------------------------------- 14 a cc 14 mn 0000006300000063 14 mx 0000006300000063 14 sp -------------------------------- 15 a ch 15 mn 0000006300000068 15 mx 0000006300000068 15 sp -------------------------------- 16 a aa_ 16 mn 000000610000006100000009 16 mx 00000061000000610000FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 000000630000006300000009 17 mx 00000063000000630000FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 000000630000006800000009 18 mx 00000063000000680000FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00000061000000610000000900000009 19 mx 00000061000000610000FFFF0000FFFF 19 sp -------------------------------- 20 a cc% 20 mn 00000063000000630000000900000009 20 mx 00000063000000630000FFFF0000FFFF 20 sp -------------------------------- 21 a ch% 21 mn 00000063000000680000000900000009 21 mx 00000063000000680000FFFF0000FFFF 21 sp -------------------------------- 22 a aaa 22 mn 000000610000006100000061 22 mx 000000610000006100000061 22 sp -------------------------------- 23 a ccc 23 mn 000000630000006300000063 23 mx 000000630000006300000063 23 sp -------------------------------- 24 a cch 24 mn 000000630000006300000068 24 mx 000000630000006300000068 24 sp -------------------------------- 25 a aaa_ 25 mn 00000061000000610000006100000009 25 mx 0000006100000061000000610000FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 00000063000000630000006300000009 26 mx 0000006300000063000000630000FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 00000063000000630000006800000009 27 mx 0000006300000063000000680000FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00000061000000610000006100000009 28 mx 0000006100000061000000610000FFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00000063000000630000006300000009 29 mx 0000006300000063000000630000FFFF 29 sp -------------------------------- 30 a cch% 30 mn 00000063000000630000006800000009 30 mx 0000006300000063000000680000FFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00000061000000610000006100000061 31 mx 00000061000000610000006100000061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00000063000000610000006100000061 32 mx 00000063000000610000006100000061 32 sp -------------------------------- 33 a Х 33 mn 00000425 33 mx 00000425 33 sp -------------------------------- 34 a џ 34 mn 0000045F 34 mx 0000045F 34 sp -------------------------------- 35 a ┥ 35 mn 00002525 35 mx 00002525 35 sp -------------------------------- 36 a 彟 36 mn 00005F5F 36 mx 00005F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_czech_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 00000009 2 mx 0000FFFF 2 sp -------------------------------- 3 a % 3 mn 00000009000000090000000900000009 3 mx 0000FFFF0000FFFF0000FFFF0000FFFF 3 sp -------------------------------- 4 a \_ 4 mn 0000005F 4 mx 0000005F 4 sp -------------------------------- 5 a \% 5 mn 00000025 5 mx 00000025 5 sp -------------------------------- 6 a \ 6 mn 0000005C 6 mx 0000005C 6 sp -------------------------------- 7 a a 7 mn 00000061 7 mx 00000061 7 sp -------------------------------- 8 a c 8 mn 00000063 8 mx 00000063 8 sp -------------------------------- 9 a a_ 9 mn 0000006100000009 9 mx 000000610000FFFF 9 sp -------------------------------- 10 a c_ 10 mn 00000009000000090000000900000009 10 mx 0000FFFF0000FFFF0000FFFF0000FFFF 10 sp -------------------------------- 11 a a% 11 mn 00000061000000090000000900000009 11 mx 000000610000FFFF0000FFFF0000FFFF 11 sp -------------------------------- 12 a c% 12 mn 00000009000000090000000900000009 12 mx 0000FFFF0000FFFF0000FFFF0000FFFF 12 sp -------------------------------- 13 a aa 13 mn 0000006100000061 13 mx 0000006100000061 13 sp -------------------------------- 14 a cc 14 mn 0000006300000063 14 mx 0000006300000063 14 sp -------------------------------- 15 a ch 15 mn 0000006300000068 15 mx 0000006300000068 15 sp -------------------------------- 16 a aa_ 16 mn 000000610000006100000009 16 mx 00000061000000610000FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 00000063000000090000000900000009 17 mx 000000630000FFFF0000FFFF0000FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 000000630000006800000009 18 mx 00000063000000680000FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00000061000000610000000900000009 19 mx 00000061000000610000FFFF0000FFFF 19 sp -------------------------------- 20 a cc% 20 mn 00000063000000090000000900000009 20 mx 000000630000FFFF0000FFFF0000FFFF 20 sp -------------------------------- 21 a ch% 21 mn 00000063000000680000000900000009 21 mx 00000063000000680000FFFF0000FFFF 21 sp -------------------------------- 22 a aaa 22 mn 000000610000006100000061 22 mx 000000610000006100000061 22 sp -------------------------------- 23 a ccc 23 mn 000000630000006300000063 23 mx 000000630000006300000063 23 sp -------------------------------- 24 a cch 24 mn 000000630000006300000068 24 mx 000000630000006300000068 24 sp -------------------------------- 25 a aaa_ 25 mn 00000061000000610000006100000009 25 mx 0000006100000061000000610000FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 00000063000000630000000900000009 26 mx 00000063000000630000FFFF0000FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 00000063000000630000006800000009 27 mx 0000006300000063000000680000FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00000061000000610000006100000009 28 mx 0000006100000061000000610000FFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00000063000000630000000900000009 29 mx 00000063000000630000FFFF0000FFFF 29 sp -------------------------------- 30 a cch% 30 mn 00000063000000630000006800000009 30 mx 0000006300000063000000680000FFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00000061000000610000006100000061 31 mx 00000061000000610000006100000061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00000063000000610000006100000061 32 mx 00000063000000610000006100000061 32 sp -------------------------------- 33 a Х 33 mn 00000425 33 mx 00000425 33 sp -------------------------------- 34 a џ 34 mn 0000045F 34 mx 0000045F 34 sp -------------------------------- 35 a ┥ 35 mn 00002525 35 mx 00002525 35 sp -------------------------------- 36 a 彟 36 mn 00005F5F 36 mx 00005F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_danish_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 00000009 2 mx 0000FFFF 2 sp -------------------------------- 3 a % 3 mn 00000009000000090000000900000009 3 mx 0000FFFF0000FFFF0000FFFF0000FFFF 3 sp -------------------------------- 4 a \_ 4 mn 0000005F 4 mx 0000005F 4 sp -------------------------------- 5 a \% 5 mn 00000025 5 mx 00000025 5 sp -------------------------------- 6 a \ 6 mn 0000005C 6 mx 0000005C 6 sp -------------------------------- 7 a a 7 mn 00000061 7 mx 00000061 7 sp -------------------------------- 8 a c 8 mn 00000063 8 mx 00000063 8 sp -------------------------------- 9 a a_ 9 mn 00000009000000090000000900000009 9 mx 0000FFFF0000FFFF0000FFFF0000FFFF 9 sp -------------------------------- 10 a c_ 10 mn 0000006300000009 10 mx 000000630000FFFF 10 sp -------------------------------- 11 a a% 11 mn 00000009000000090000000900000009 11 mx 0000FFFF0000FFFF0000FFFF0000FFFF 11 sp -------------------------------- 12 a c% 12 mn 00000063000000090000000900000009 12 mx 000000630000FFFF0000FFFF0000FFFF 12 sp -------------------------------- 13 a aa 13 mn 0000006100000061 13 mx 0000006100000061 13 sp -------------------------------- 14 a cc 14 mn 0000006300000063 14 mx 0000006300000063 14 sp -------------------------------- 15 a ch 15 mn 0000006300000068 15 mx 0000006300000068 15 sp -------------------------------- 16 a aa_ 16 mn 000000610000006100000009 16 mx 00000061000000610000FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 000000630000006300000009 17 mx 00000063000000630000FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 000000630000006800000009 18 mx 00000063000000680000FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00000061000000610000000900000009 19 mx 00000061000000610000FFFF0000FFFF 19 sp -------------------------------- 20 a cc% 20 mn 00000063000000630000000900000009 20 mx 00000063000000630000FFFF0000FFFF 20 sp -------------------------------- 21 a ch% 21 mn 00000063000000680000000900000009 21 mx 00000063000000680000FFFF0000FFFF 21 sp -------------------------------- 22 a aaa 22 mn 000000610000006100000061 22 mx 000000610000006100000061 22 sp -------------------------------- 23 a ccc 23 mn 000000630000006300000063 23 mx 000000630000006300000063 23 sp -------------------------------- 24 a cch 24 mn 000000630000006300000068 24 mx 000000630000006300000068 24 sp -------------------------------- 25 a aaa_ 25 mn 00000061000000610000000900000009 25 mx 00000061000000610000FFFF0000FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 00000063000000630000006300000009 26 mx 0000006300000063000000630000FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 00000063000000630000006800000009 27 mx 0000006300000063000000680000FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00000061000000610000000900000009 28 mx 00000061000000610000FFFF0000FFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00000063000000630000006300000009 29 mx 0000006300000063000000630000FFFF 29 sp -------------------------------- 30 a cch% 30 mn 00000063000000630000006800000009 30 mx 0000006300000063000000680000FFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00000061000000610000006100000061 31 mx 00000061000000610000006100000061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00000063000000610000006100000009 32 mx 0000006300000061000000610000FFFF 32 sp -------------------------------- 33 a Х 33 mn 00000425 33 mx 00000425 33 sp -------------------------------- 34 a џ 34 mn 0000045F 34 mx 0000045F 34 sp -------------------------------- 35 a ┥ 35 mn 00002525 35 mx 00002525 35 sp -------------------------------- 36 a 彟 36 mn 00005F5F 36 mx 00005F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_thai_520_w2; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 00000009 2 mx 0000FFFF 2 sp -------------------------------- 3 a % 3 mn 00000009000000090000000900000009 3 mx 0000FFFF0000FFFF0000FFFF0000FFFF 3 sp -------------------------------- 4 a \_ 4 mn 0000005F 4 mx 0000005F 4 sp -------------------------------- 5 a \% 5 mn 00000025 5 mx 00000025 5 sp -------------------------------- 6 a \ 6 mn 0000005C 6 mx 0000005C 6 sp -------------------------------- 7 a a 7 mn 00000061 7 mx 00000061 7 sp -------------------------------- 8 a c 8 mn 00000063 8 mx 00000063 8 sp -------------------------------- 9 a a_ 9 mn 0000006100000009 9 mx 000000610000FFFF 9 sp -------------------------------- 10 a c_ 10 mn 0000006300000009 10 mx 000000630000FFFF 10 sp -------------------------------- 11 a a% 11 mn 00000061000000090000000900000009 11 mx 000000610000FFFF0000FFFF0000FFFF 11 sp -------------------------------- 12 a c% 12 mn 00000063000000090000000900000009 12 mx 000000630000FFFF0000FFFF0000FFFF 12 sp -------------------------------- 13 a aa 13 mn 0000006100000061 13 mx 0000006100000061 13 sp -------------------------------- 14 a cc 14 mn 0000006300000063 14 mx 0000006300000063 14 sp -------------------------------- 15 a ch 15 mn 0000006300000068 15 mx 0000006300000068 15 sp -------------------------------- 16 a aa_ 16 mn 000000610000006100000009 16 mx 00000061000000610000FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 000000630000006300000009 17 mx 00000063000000630000FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 000000630000006800000009 18 mx 00000063000000680000FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00000061000000610000000900000009 19 mx 00000061000000610000FFFF0000FFFF 19 sp -------------------------------- 20 a cc% 20 mn 00000063000000630000000900000009 20 mx 00000063000000630000FFFF0000FFFF 20 sp -------------------------------- 21 a ch% 21 mn 00000063000000680000000900000009 21 mx 00000063000000680000FFFF0000FFFF 21 sp -------------------------------- 22 a aaa 22 mn 000000610000006100000061 22 mx 000000610000006100000061 22 sp -------------------------------- 23 a ccc 23 mn 000000630000006300000063 23 mx 000000630000006300000063 23 sp -------------------------------- 24 a cch 24 mn 000000630000006300000068 24 mx 000000630000006300000068 24 sp -------------------------------- 25 a aaa_ 25 mn 00000061000000610000006100000009 25 mx 0000006100000061000000610000FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 00000063000000630000006300000009 26 mx 0000006300000063000000630000FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 00000063000000630000006800000009 27 mx 0000006300000063000000680000FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00000061000000610000006100000009 28 mx 0000006100000061000000610000FFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00000063000000630000006300000009 29 mx 0000006300000063000000630000FFFF 29 sp -------------------------------- 30 a cch% 30 mn 00000063000000630000006800000009 30 mx 0000006300000063000000680000FFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00000061000000610000006100000061 31 mx 00000061000000610000006100000061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00000063000000610000006100000061 32 mx 00000063000000610000006100000061 32 sp -------------------------------- 33 a Х 33 mn 00000425 33 mx 00000425 33 sp -------------------------------- 34 a џ 34 mn 0000045F 34 mx 0000045F 34 sp -------------------------------- 35 a ┥ 35 mn 00002525 35 mx 00002525 35 sp -------------------------------- 36 a 彟 36 mn 00005F5F 36 mx 00005F5F 36 sp -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf32 COLLATE utf32_unicode_520_ci; SELECT * FROM v1; id name val 1 a 1 mn 1 mx 1 sp -------------------------------- 2 a _ 2 mn 00000009 2 mx 0010FFFF 2 sp -------------------------------- 3 a % 3 mn 00000009000000090000000900000009 3 mx 0010FFFF0010FFFF0010FFFF0010FFFF 3 sp -------------------------------- 4 a \_ 4 mn 0000005F 4 mx 0000005F 4 sp -------------------------------- 5 a \% 5 mn 00000025 5 mx 00000025 5 sp -------------------------------- 6 a \ 6 mn 0000005C 6 mx 0000005C 6 sp -------------------------------- 7 a a 7 mn 00000061 7 mx 00000061 7 sp -------------------------------- 8 a c 8 mn 00000063 8 mx 00000063 8 sp -------------------------------- 9 a a_ 9 mn 0000006100000009 9 mx 000000610010FFFF 9 sp -------------------------------- 10 a c_ 10 mn 0000006300000009 10 mx 000000630010FFFF 10 sp -------------------------------- 11 a a% 11 mn 00000061000000090000000900000009 11 mx 000000610010FFFF0010FFFF0010FFFF 11 sp -------------------------------- 12 a c% 12 mn 00000063000000090000000900000009 12 mx 000000630010FFFF0010FFFF0010FFFF 12 sp -------------------------------- 13 a aa 13 mn 0000006100000061 13 mx 0000006100000061 13 sp -------------------------------- 14 a cc 14 mn 0000006300000063 14 mx 0000006300000063 14 sp -------------------------------- 15 a ch 15 mn 0000006300000068 15 mx 0000006300000068 15 sp -------------------------------- 16 a aa_ 16 mn 000000610000006100000009 16 mx 00000061000000610010FFFF 16 sp -------------------------------- 17 a cc_ 17 mn 000000630000006300000009 17 mx 00000063000000630010FFFF 17 sp -------------------------------- 18 a ch_ 18 mn 000000630000006800000009 18 mx 00000063000000680010FFFF 18 sp -------------------------------- 19 a aa% 19 mn 00000061000000610000000900000009 19 mx 00000061000000610010FFFF0010FFFF 19 sp -------------------------------- 20 a cc% 20 mn 00000063000000630000000900000009 20 mx 00000063000000630010FFFF0010FFFF 20 sp -------------------------------- 21 a ch% 21 mn 00000063000000680000000900000009 21 mx 00000063000000680010FFFF0010FFFF 21 sp -------------------------------- 22 a aaa 22 mn 000000610000006100000061 22 mx 000000610000006100000061 22 sp -------------------------------- 23 a ccc 23 mn 000000630000006300000063 23 mx 000000630000006300000063 23 sp -------------------------------- 24 a cch 24 mn 000000630000006300000068 24 mx 000000630000006300000068 24 sp -------------------------------- 25 a aaa_ 25 mn 00000061000000610000006100000009 25 mx 0000006100000061000000610010FFFF 25 sp -------------------------------- 26 a ccc_ 26 mn 00000063000000630000006300000009 26 mx 0000006300000063000000630010FFFF 26 sp -------------------------------- 27 a cch_ 27 mn 00000063000000630000006800000009 27 mx 0000006300000063000000680010FFFF 27 sp -------------------------------- 28 a aaa% 28 mn 00000061000000610000006100000009 28 mx 0000006100000061000000610010FFFF 28 sp -------------------------------- 29 a ccc% 29 mn 00000063000000630000006300000009 29 mx 0000006300000063000000630010FFFF 29 sp -------------------------------- 30 a cch% 30 mn 00000063000000630000006800000009 30 mx 0000006300000063000000680010FFFF 30 sp -------------------------------- 31 a aaaaaaaaaaaaaaaaaaaa 31 mn 00000061000000610000006100000061 31 mx 00000061000000610000006100000061 31 sp -------------------------------- 32 a caaaaaaaaaaaaaaaaaaa 32 mn 00000063000000610000006100000061 32 mx 00000063000000610000006100000061 32 sp -------------------------------- 33 a Х 33 mn 00000425 33 mx 00000425 33 sp -------------------------------- 34 a џ 34 mn 0000045F 34 mx 0000045F 34 sp -------------------------------- 35 a ┥ 35 mn 00002525 35 mx 00002525 35 sp -------------------------------- 36 a 彟 36 mn 00005F5F 36 mx 00005F5F 36 sp -------------------------------- DROP VIEW v1; DROP TABLE t1; # # Start of 10.2 tests # # # MDEV-10134 Add full support for DEFAULT # CREATE TABLE t1 ( a VARCHAR(10), mn VARCHAR(10) DEFAULT LIKE_RANGE_MIN(a,10), mx VARCHAR(10) DEFAULT LIKE_RANGE_MAX(a,10) ); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL, `mn` varchar(10) DEFAULT like_range_min(`a`,10), `mx` varchar(10) DEFAULT like_range_max(`a`,10) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 INSERT INTO t1 (a) VALUES ('a'),('a_'),('a%'); SELECT a, HEX(mn), HEX(mx) FROM t1; a HEX(mn) HEX(mx) a 61 61 a_ 6100 61FF a% 61000000000000000000 61FFFFFFFFFFFFFFFFFF DROP TABLE t1; # # MDEV-14350 Index use with collation utf8mb4_unicode_nopad_ci on LIKE pattern with wrong results # CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_nopad_ci); INSERT INTO t1 VALUES ('111%'); SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; a HEX(LIKE_RANGE_MIN(a,200)) 111% 313131 DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_nopad_ci); INSERT INTO t1 VALUES ('111%'); SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; a HEX(LIKE_RANGE_MIN(a,200)) 111% 313131 DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_nopad_ci); INSERT INTO t1 VALUES ('111%'); SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; a HEX(LIKE_RANGE_MIN(a,200)) 111% 313131 DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_nopad_ci); INSERT INTO t1 VALUES ('111%'); SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; a HEX(LIKE_RANGE_MIN(a,200)) 111% 313131 DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET ucs2 COLLATE ucs2_unicode_nopad_ci); INSERT INTO t1 VALUES ('111%'); SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; a HEX(LIKE_RANGE_MIN(a,200)) 111% 003100310031 DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf16 COLLATE utf16_unicode_nopad_ci); INSERT INTO t1 VALUES ('111%'); SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; a HEX(LIKE_RANGE_MIN(a,200)) 111% 003100310031 DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf32 COLLATE utf32_unicode_nopad_ci); INSERT INTO t1 VALUES ('111%'); SELECT a, HEX(LIKE_RANGE_MIN(a,200)) FROM t1; a HEX(LIKE_RANGE_MIN(a,200)) 111% 000000310000003100000031 DROP TABLE t1; # # End of 10.2 tests #