[Interest] Qt Sql BLOB data converting

Christian Ehrlicher Ch.Ehrlicher at gmx.de
Mon Nov 28 19:59:47 CET 2022

Am 28.11.2022 um 19:46 schrieb Yauheni Pervenenka:
> Christian, thanks for your effort, db was simplified for test, is it
> possible to fix it on the client side? Any ideas, why is column
> considered as SQLITE_TEXT if it is BLOB?
It's because of the dynamic typing feature of sqlite (
https://www.sqlite.org/flextypegood.html ) - even a column is created as
one type it can contain another one. Looks like the data was inserted
with the wrong type information since your blob data is for sure no
readable string.

A cast seems to work: "SELECT cast(value AS BLOB) from test"


More information about the Interest mailing list