[Interest] Qt Sql BLOB data converting
Thiago Macieira
thiago.macieira at intel.com
Mon Nov 28 20:20:35 CET 2022
On Monday, 28 November 2022 10:59:47 PST Christian Ehrlicher wrote:
> 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.
Thanks for the explanation, Christian. I can confirm that the type comes out
correctly if it is inserted into the table AS blob, not as plaintext.
Therefore, the problem is on the insertion side, not in the SELECT or QtSql.
I've closed the task.
--
Thiago Macieira - thiago.macieira (AT) intel.com
Cloud Software Architect - Intel DCAI Cloud Engineering
More information about the Interest
mailing list