masteraler / qsqlbuilder Goto Github PK

Your library is amazing and is proving to be very helpful :)

Thank you!

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