[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