Christian, thanks a lot it is work now, fine On Mon, Nov 28, 2022 at 10:01 PM Christian Ehrlicher <[email protected]> wrote:
> > 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 >
_______________________________________________ Interest mailing list [email protected] https://lists.qt-project.org/listinfo/interest
