QT Mysql数据库插入问题

[djq87823182]

程序能连上数据库，能查询，能删除，但是不能插入，进行插入的时候会报错，错误如下：
Using unsupported buffer type: 64 (parameter: 1) QMYSQL3: Unable to bind value
请问要怎么解决？关键代码如下：

assert(NULL == m_current->parent());
	p2p_resource* res = NULL;
	if (NULL == (res = m_current->get_res())) {
		assert(m_modified);
		QString sql = QString("UPDATE ppdb_resources SET res_name='%1',res_desc='%2'").arg(m_main_win.r_ed_res_name->text(), m_main_win.r_ed_res_desc->toPlainText());
		QSqlQuery q;
		if (q.exec(sql)) {
			m_modified = false;
			m_main_win.r_bt_if_commit->hide();
			m_main_win.r_bt_if_export->show();
			if (m_current->childCount() > 0) {
				m_main_win.r_bt_sh_export->show();
			} else {
				m_main_win.r_bt_sh_export->hide();
			}
		} else {
			QMessageBox::information(this, tr("提示"), QString(tr("保存失败")).append(q.lastError().text()));
		}
	} else {
		if (m_modified) {
			res->set_name(m_main_win.r_ed_res_name->text());
			res->set_desc(m_main_win.r_ed_res_desc->toPlainText());
			m_modified = false;
		}
		QString sql = QString("INSERT INTO ppdb_resources(res_file,res_name,res_desc,res_hash,res_size,res_seed,res_piece,res_stamp) VALUES('%1','%2','%3',?,%4,?,%5,UNIX_TIMESTAMP())").arg(res->get_file(), res->get_name(), res->get_desc()).arg(res->get_file_size()).arg(res->get_piece_count());

		//QString sql = QString("INSERT INTO ppdb_resources(res_file,res_name,res_desc,res_hash,res_size,res_seed,res_piece,res_stamp) VALUES('%1','%2','%3',%4,%5,?,%5,UNIX_TIMESTAMP())").arg(res->get_file(), res->get_name(), res->get_desc()).arg(QVariant(QByteArray(res->get_hash(), P_TYPE_LEN_HASH))).arg(res->get_file_size()).arg(res->get_piece_count());
		QSqlQuery q;
		if (!q.prepare(sql)) {
			QMessageBox::information(this, tr("提示"), QString(tr("保存失败")).append(q.lastError().text()));
			return;
		}
		/*
		q.bindValue(":hash", res->get_hash());
		q.bindValue(":seed", res->get_seed());
		*/
		q.addBindValue(QVariant(QByteArray(res->get_hash(), P_TYPE_LEN_HASH)));
		q.addBindValue(QVariant(QByteArray(res->get_seed(), res->get_seed_size())));
		
		
		if (q.exec()) {
			delete res;
			m_current->set_uid(q.lastInsertId().toUInt());
			m_current->set_res(NULL);
			
			m_current->setText(1, QObject::tr("已保存"));
			p2p_tree_item* tmp = m_current;
			m_current = NULL;
			m_main_win.r_main_tree->setCurrentItem(tmp);
			_on_item_selected();
		} else {
			QMessageBox::information(this, tr("提示"), QString(tr("保存失败")).append(q.lastError().text()));
		}
	}

[gnimgnot]

sql参数？

[p89787259]

lz 应该是sql的问题，试下我的这个sql：

QString insertSql = "insert into ppdb_resources(res_file,res_name,res_desc,res_hash,res_size,res_seed,res_piece,res_stamp)"
            "values ( \"%1\", \"%2\", \"%3\", \"%4\", \"%5\", \"%6\", \"%7\", UNIX_TIMESTAMP());";
QString sql = insertSql.arg(res->get_file())
            .arg(res->get_name())
            .arg(res->get_desc())
            .arg(res->get_hash())
            .arg(res->get_file_size())
            .arg(res->get_seed())
            .arg(res->get_piece_count());