DevHeads.net

LONGTEXT with STORAGE DISK

Hi,

as we figured out , that VARCHAR(100) will consume at least 100+4 bytes
or even 3x more for UTF8.

We are wondering how much space is consumed for LONGTEXT with following
definition

CREATE TABLE `TM` (

`Id` bigint(20) NOT NULL AUTO_INCREMENT,

`Content` longtext );

ALTER TABLE `TM` TABLESPACE ts_cmn_free STORAGE DISK ENGINE NDBCLUSTER;

Cheers Helmut