hello: i have the following table in the database test_transaction
-- -- Table structure for table `test_blob` -- CREATE TABLE `test_blob` ( `f1` blob NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; i saw the files in the mysql var directory $ ls -l test_transaction/test_blob.frm -rw-rw---- 1 mysql mysql 8556 May 12 20:04 test_transaction/test_blob.frm so this is an approx 8k file. now i added 2 rows each with binary files of size 8k but when i list test_blob.frm the size remains unchanged (still 8556 bytes). Where are the blob datatypes stored ? i did a bit of reading in the manual it mentions they are stored in hidden tables ? if so, is it possible to see these hidden tables and the entries / sizes of rows in them ? thanks. yashesh bhatia ---------------------------------------------------------------- Go Pre http://www2.localaccess.com/rlalonde/pre.htm ---------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
