Hello, I can see MyISAM stores BLOB column as same space as other data type column, but InnoDB doesn't. (If you mean "same .ibd file" it's true)
http://dev.mysql.com/doc/refman/5.6/en/innodb-row-format-overview.html ROW_FORMAT= Compact holds first 768 bytes of BLOB column, ROW_FORMAT= Dynamic or Compressed holds first 20bytes of column. http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-compression-internals-storage-blobs.html 2014-05-26 18:56 GMT+09:00 Reindl Harald <h.rei...@thelounge.net>: > > 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 > >
