QString query_str;
QSqlQuery query;
query_str = "INSERT INTO T_MSG (F_RECORD_NMB, F_MSG_TEXT_VC, F_MSG_TEXT_B) "
  "VALUES (3, 'PRIVET3: ПРИВЕТ3', 'PRIVET3: ПРИВЕТ3')";
query.exec(query_str);
query_str = "INSERT INTO T_MSG (F_RECORD_NMB, F_MSG_TEXT_VC, F_MSG_TEXT_B) "
  "VALUES (4, 'PRIVET4: ПРИВЕТ4', 'PRIVET4: ПРИВЕТ4')";
query.exec(query_str);

    if (!query.prepare("INSERT INTO T_MSG "
                  "(F_RECORD_NMB, F_MSG_TEXT_VC, F_MSG_TEXT_B) "
                  "VALUES (:F_RECORD_NMB, :F_MSG_TEXT_VC, :F_MSG_TEXT_B)")) {
        qDebug() << "не удалось успешно подготовить запрос";
        return 1;
    }
    query.bindValue(":F_RECORD_NMB", 7);
    query.bindValue(":F_MSG_TEXT_VC", "PRIVET7: ПРИВЕТ7");
    query.bindValue(":F_MSG_TEXT_B", "PRIVET7: ПРИВЕТ7");
    query.exec();
    if (!query.isActive()) {
        qDebug() << "не удалось успешно выполнить запрос:"
                << query.lastError().text();
        return 2;
    }

CREATE TABLE T_MSG
(
    F_RECORD_NMB  BIGINT NOT NULL,
    F_MSG_TEXT    BLOB SUB_TYPE 0 SEGMENT SIZE 80 NOT NULL
);

    QString myQString = "PRIVET8: ПРИВЕТ8";
    std::string myStdString = myQString.toStdString();

Цитата(Steklova Olga @ 16.3.2012, 13:41)

QSqlQuery s;
      s.prepare( QString( "update TABLE set  FIELD=:marker where ... " ) );
      s.addBindValue( QVariant (myStdString.c_str()), QSql::In/*|QSql::Binary*/ );
      s.exec( );

CREATE DOMAIN D_VARCHAR_0020 AS
VARCHAR(20) CHARACTER SET WIN1251
COLLATE PXW_CYRL;

CREATE DOMAIN D_BLOB_TEXT_0020 AS
BLOB SUB_TYPE 1 SEGMENT SIZE 20 --SUB_TYPE 1 == TEXT
CHARACTER SET WIN1251;

CREATE DOMAIN D_BLOB_BINARY_0020 AS
BLOB SUB_TYPE 0 SEGMENT SIZE 20; --SUB_TYPE 0 == BINARY

CREATE TABLE T_MSG (
    F_RECORD_NMB D_INTEGER NOT NULL,
    F_MSG_TEXT_VC D_VARCHAR_0020 NOT NULL,
    F_MSG_TEXT_B D_BLOB_TEXT_0020 NOT NULL,
    F_MSG_TEXT_BIN D_BLOB_BINARY_0020 NOT NULL
);

    if (!query.prepare("INSERT INTO T_MSG "
                  "(F_RECORD_NMB, F_MSG_TEXT_VC, F_MSG_TEXT_B, F_MSG_TEXT_BIN) "
                  "VALUES (:F_RECORD_NMB, :F_MSG_TEXT_VC, :F_MSG_TEXT_B, :F_MSG_TEXT_BIN)")) {
        qDebug() << "не удалось успешно подготовить запрос";
        return 1;
    }
    query.bindValue(":F_RECORD_NMB", 7);
    query.bindValue(":F_MSG_TEXT_VC", "PRIVET7: ПРИВЕТ7");
    query.bindValue(":F_MSG_TEXT_B", "PRIVET7: ПРИВЕТ7");

    QString myQString = "PRIVET7: ПРИВЕТ7";
    std::string myStdString = myQString.toStdString();
    query.bindValue(":F_MSG_TEXT_BIN", QVariant(myStdString.c_str()), QSql::In | QSql::Binary);

    query.exec();
    if (!query.isActive()) {
        qDebug() << "не удалось успешно выполнить запрос:"
                << query.lastError().text();
        return 2;
    }

#define RUSCODEC "CP1251"
QTextCodec::setCodecForCStrings(QTextCodec::codecForName(RUSCODEC));