Edit File: ctype_like_range.result
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'); 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 -------------------------------- 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 -------------------------------- ALTER TABLE t1 MODIFY a VARCHAR(32) CHARACTER SET utf8; 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- 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 -------------------------------- DROP VIEW v1; DROP TABLE t1;
Back to File Manager