[Interest] Qt Sql BLOB data converting
yauheni.pervenenka at viber.com
Mon Nov 28 20:09:11 CET 2022
Christian, thanks a lot it is work now, fine
On Mon, Nov 28, 2022 at 10:01 PM Christian Ehrlicher <Ch.Ehrlicher at gmx.de>
> 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"
> Interest mailing list
> Interest at qt-project.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Interest