mixing data types: MariaDB [test]> INSERT INTO table_compressed SELECT * FROM table_without_compression2; ERROR 1406 (22001): Data too long for column 'data' at row 1 MariaDB [test]> INSERT INTO table_compressed2 SELECT * FROM table_without_compression; ERROR 1406 (22001): Data too long for column 'data' at row 1 ---- creating now a LONGBLOB / LONGTEXT MariaDB [test]> *CREATE TABLE table_compressed_long_blob (* * -> `id` int(11) NOT NULL DEFAULT 0,* * -> `gmtime` decimal(22,7) NOT NULL DEFAULT 0.0000000,* * -> `data` LONGBLOB COMPRESSED NOT NULL,* * -> PRIMARY KEY (`id`,`gmtime`)* * -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;* *Query OK, 0 rows affected (0.141 sec)* MariaDB [test]> *CREATE TABLE table_compressed_long_text (* * -> `id` int(11) NOT NULL DEFAULT 0,* * -> `gmtime` decimal(22,7) NOT NULL DEFAULT 0.0000000,* * -> `data` LONGTEXT COMPRESSED NOT NULL,* * -> PRIMARY KEY (`id`,`gmtime`)* * -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;* *Query OK, 0 rows affected (0.161 sec)* MariaDB [test]> *INSERT INTO table_compressed_long_blob SELECT * FROM table_without_compression2;* *Query OK, 1 row affected (0.045 sec) <- NICE! * *Records: 1 Duplicates: 0 Warnings: 0* MariaDB [test]> *INSERT INTO table_compressed_long_text SELECT * FROM table_without_compression2;* *Query OK, 1 row affected (0.009 sec) <- NICE!* *Records: 1 Duplicates: 0 Warnings: 0*