Could anyone further assist me on how to clear the buffer in the ODBC driver. The reason I asked this is that I have a select statement and a Insert statement, and they are prepared once and executed multiple times. I use select to check if a record already exist and retrieving data. The...
I thought of that too. But that is what my boss wants, so I just have to follow the direction. He might want to have every transaction going through the database.
Assume I break the 4GB into 512MB chunks, there will be a 8 pieces(rows) sharing a common ID. So the problem with storing 4GB seems to be solved. When it comes to retrieve data from the database with this common ID, it could be another problem because it will retrieve 4GB in multiple rows...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.