Hi, > -----Original Message----- > From: Shankar Unni [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 06, 2002 9:29 AM > To: Yoram Naim > Cc: '[EMAIL PROTECTED]' > Subject: Re: blob field > > > [redirecting to mysql list because of general interest] > > Yoram Naim wrote: > > > Can some one send me a code sample (C , CPP ) > > How can I copy file data to MYSQL BLOB field > > but not in one piece . > > > Is this even possible? If so, I'm sure that the JDBC driver could use such > a feature to stream large blobs to the database (currently, in 3.23, we're > stuck with the 16MB single-packet limitation). > --
Its possible with MyODBC Drivers to 'n' size. You can supply BLOB/CLOB data in pieces to desired size by making use of SQLParamData and SQLPutData APIs. Here is a simple examples using 'C-ODBC'. 1. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbc sending_long_data.asp 2. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbc sqlputdata.asp I think it should also be possible with MmDriver, but never tested. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.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