cannot insert file binary

I tried to put binary file(varbinary(max)) into sql server using this library.
fileBinary data type is QByteArray.

        auto queryResult = Query(FILE)
            .insert({"customer_id", "file_name", "file_binary"})
            .values({customerId, fileName.data(), fileBinary})
            .perform();

This is causing follows;
StatementError: [Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from data type varchar(max) to varbinary(max) is not allowed. Use the CONVERT function to run this query. QODBC3: Unable to execute statement

Same problem here, but in sqlite3.

Problem is that author of this project converts whole universe to QString, e.g.:

QList<int> InserterPerformer::perform() &&
{
    QList<int> result;

    QStringList valueTail;
    for(const QVariantList& dataTuple : impl->m_data)
    {
        QStringList vBlock;
        for(const QVariant& value : dataTuple)
            vBlock << OP::Clause::escapeValue(value);

        valueTail << QString("(%1)").arg(vBlock.join(','));
    }

Seeing no activity in past 2 years this project is unfortunately unusable.

@aaronDevLinux

@aaronDevLinux , @harry-chin yepp, that was a prototype of some code that became proprietary
Now I'm free from legal limitations and can fix whatever issues here.

Sorry for abandoning the github for a while.

Also column disambiguation sucks for complex SQL, I'll probably bring in some simple scheme support to improve that

Navigation Menu

Repository navigation

cannot insert file binary #1

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

cannot insert file binary #1

Description

Activity

aaronDevLinux commented on Feb 26, 2025

MasterAler commented on Dec 26, 2025

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions