[Interest] Qt Sql BLOB data converting

[Christian Ehrlicher]

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