--- Egor Egorov <[EMAIL PROTECTED]> wrote: > deep, > Thursday, August 08, 2002, 4:08:22 PM, you wrote: > > dk> It looks like a simple bug but I have spent lots > of > dk> hours try to solved it but not success yet. > > dk> Application: Visual Basic 6.0 > dk> Database used: MySQL 4.0.1 & MySQL 4.0.2 > dk> ODBC: MyODBC 3.51.03 > > dk> I have created a table which contains the BLOB > field > dk> for storing images, but when I create a > recordset on > dk> that table and check the DefinedSize property of > that > dk> field it returns 64K which means I cannot store > images > dk> bigger than 64K. > > Table Structure --> > dk> CREATE TABLE Attachment > dk> ( > dk> AttachmenId INT AUTO_INCREMENT NOT NULL PRIMARY, > dk> AttachmentName VARCHAR(255), > dk> Attachment BLOB > dk> )TYPE = InnoDB > > It's not a bug, 64K is the maximum size of BLOB :) > Use LONGBLOB instead. > I have changed the datatype to LONGBLOB but problem is still unsolved, the DefinedSize property of ADO recordset for Attachment fields still says its 64K.
__________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php