Re: How to insert a binary data size of 4GB into a longblob column.

crazyODBC wrote:
> I was using unixODBC as the driver manager and mysql ODBC driver to connect
> to the mysql server.  I am using Linux platform and coding with C++.  I had
> created a table with a column type of longblob and wish to use ODBC function
> call to insert a 4GB of data into the mysql database.  At first, I got error
> saying that the data size is over the limit of max_allowed_packet size, so I
> changed the max_allowed_packet to around 1GB (that is the max
> max_allowed_packet variable can take).  Then I start to sent a 1GB data to
> the mysql database.  It will complaint about "Out of memory (Needed
> 500000048 bytes)".  Seems like I could only sent max of 500 MB of data,
> otherwise the mysql server will complaint about the above out of memory
> problem.  Not sure how to get around this problem.  Could any help, Thanks
> in advance.   

What ODBC call are you using to insert the data? I think you need to 
insert it in small chunks using SQLPutData.

Martin

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx