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" Christian _______________________________________________ Interest mailing list [email protected] https://lists.qt-project.org/listinfo/interest
