I can see MyISAM stores BLOB column as same space as other data type
but InnoDB doesn't. (If you mean "same .ibd file" it's true)
ROW_FORMAT= Compact holds first 768 bytes of BLOB column,
ROW_FORMAT= Dynamic or Compressed holds first 20bytes of column.
2014-05-26 18:56 GMT+09:00 Reindl Harald <h.reindl@stripped>:
> Am 26.05.2014 11:40, schrieb geetanjali mehra:
> > I want to know where does MyISAM and innodb stores its BLOB data ; inside
> > the table or outside the table. I tried to understand BLOB using MySQL
> > online docs but failed.
> inside the table, it's just a field type