vc往mysql插入blob数据的问题
开发环境:VS2005
mysql 版本:5.1.31 community server
使用ADO操作mysql,ODBC驱动版本是:mysql-connector-odbc-5.1.5-win32
用的同一段代码能往ACCESS里插,却不能往MYSQL中插,执行后BLOB字段为NULL。
核心代码如下:
VARIANT varBLOB;
SAFEARRAY *psa;
SAFEARRAYBOUND rgsabound[1];
rgsabound[0].lLbound = 0;
rgsabound[0].cElements = length;
psa = SafeArrayCreate(VT_UI1,1,rgsabound);
for(long i = 0;i<(long)length;i++)
{
HRESULT hr = SafeArrayPutElement(psa,&i,ptr++);
}
varBLOB.vt = VT_ARRAY | VT_UI1;
varBLOB.parray = psa;
m_pRecordset->GetFields()->GetItem("APPENDIX")->AppendChunk(varBLOB);
m_pRecordset->Update();
m_pRecordset->Close();
delete [] blob;