怎么插:我用的是mfc+odbc+sql server 如何将二进制的内容插进数据库?
BYTE *bpData;
BYTE byArray[MAX_EMS_SIZE];
iSize=MAX_EMS_SIZE;
//……取得将二进制数据长度和指针
memcpy(byArray,bpData,iSize);
sInsert.Format("insert into %s (%s,%s,%s,%s,%s,%s)values(
cast(%s as varbinary(MAX_EMS_SIZE)),'%s','%s','%s','%s','%s')"
,this->m_clsInitFile.m_structParams.cContentTableName//表名字符串
,this->m_clsInitFile.m_structParams.cContentField
,this->m_clsInitFile.m_structParams.cCategoryField
,this->m_clsInitFile.m_structParams.cKindField ,this->m_clsInitFile.m_structParams.cTypeField
,this->m_clsInitFile.m_structParams.cFileNumberField
,this->m_clsInitFile.m_structParams.cIntroField
,byArray
//,"'bin'"
,"ts","ts","1","001","测试");
提示错误
03-12-10 10:24:35 exec'insert into File (Content,Category,kind,typeID,FileNumber,Intro)values(cast(H??? as varbinary(MAX_EMS_SIZE)),'ts','ts','1','001','测试')':COUNT 字段不正确或语法错误