1# 2# MDEV-15938 - TINYTEXT CHARACTER SET utf8 COMPRESSED truncates data 3# 4CREATE TABLE t1(a TINYTEXT COMPRESSED, b TINYTEXT) CHARACTER SET utf16; 5INSERT INTO t1 VALUES (REPEAT(_latin1'a', 127), REPEAT(_latin1'a', 127)); 6SELECT CHAR_LENGTH(a), CHAR_LENGTH(b), LEFT(a, 10), LEFT(b, 10) FROM t1; 7CHAR_LENGTH(a) CHAR_LENGTH(b) LEFT(a, 10) LEFT(b, 10) 8127 127 aaaaaaaaaa aaaaaaaaaa 9DROP TABLE t1; 10