[Interest] Qt Sql BLOB data converting

[Yauheni Pervenenka]

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>
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
> Interest at qt-project.org
> https://lists.qt-project.org/listinfo/interest
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.qt-project.org/pipermail/interest/attachments/20221128/469f868e/attachment.htm>