http://dev.mysql.com/doc/refman/5.0/en/blob.html
says " See Section 11.5, "Data Type Storage Requirements". " Section 11.5 (http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html) says TINYBLOB, TINYTEXT L+1 byte, where L < 2^8 BLOB, TEXT L+2 bytes, where L < 2^16 MEDIUMBLOB, MEDIUMTEXT L+3 bytes, where L < 2^24 LONGBLOB, LONGTEXT L+4 bytes, where L < 2^32 L is the max length, and +1, +2, +3, +4 records the size of the record. HTH, Tim -----Original Message----- From: C K [mailto:[EMAIL PROTECTED] Sent: Sunday, April 16, 2006 8:33 AM To: Tim Lucia Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: Re: Right column type for OLE objects But what about size. I reffered MySQL manual for 5.0, but didn't find that what is he maximum size of binary data we can store in such column. Please help Thanks and regards, CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]