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*
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
