Found this at http://dev.mysql.com/doc/mysql/en/BLOB.html, basically it's not stored in the table row along with any other columns in the same row.
12.4.2 The BLOB and TEXT Types Each BLOB or TEXT value is represented internally by a separately allocated object. This is in contrast to all other column types, for which storage is allocated once per column when the table is opened. Ed -----Original Message----- From: Luis R. Rodriguez [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 6:37 PM To: [EMAIL PROTECTED] Subject: Where are BLOBs / TEXTs stored? [ Please CC me ] Hi, http://dev.mysql.com/doc/mysql/en/Storage_requirements.html Page says: --- "The maximum size of a row in a MyISAM table is 65,534 bytes. Each BLOB and TEXT column accounts for only five to nine bytes toward this size." --- Question: So where are BLOBs and TEXTs entries stored? Luis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]