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