Same to TEXT MariaDB [test]> *CREATE TABLE `table_compressed2` (* * -> `id` int(11) NOT NULL DEFAULT 0,* * -> `gmtime` decimal(22,7) NOT NULL DEFAULT 0.0000000,* * -> `data` text COMPRESSED NOT NULL DEFAULT '',* * -> PRIMARY KEY (`id`,`gmtime`)* * -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;* *Query OK, 0 rows affected (0.231 sec)* MariaDB [test]> *CREATE TABLE `table_without_compression2` (* * -> `id` int(11) NOT NULL DEFAULT 0,* * -> `gmtime` decimal(22,7) NOT NULL DEFAULT 0.0000000,* * -> `data` text NOT NULL,* * -> PRIMARY KEY (`id`,`gmtime`)* * -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;* *Query OK, 0 rows affected (0.253 sec)* MariaDB [test]> *INSERT INTO table_without_compression2 VALUES (1,0,repeat('a',65535));* *Query OK, 1 row affected (0.061 sec)* MariaDB [test]> *INSERT INTO table_without_compression2 VALUES (1,0,repeat('a',65536));* *ERROR 1406 (22001): Data too long for column 'data' at row 1 <- JUST TO CHECK IF WE GOT MAX SIZE OF BLOB COLUMN* MariaDB [test]> *INSERT INTO table_compressed2 SELECT * FROM table_without_compression2;* *ERROR 1406 (22001): Data too long for column 'data' at row 1*