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



_______________________________________________
Interest mailing list
Interest@qt-project.org
https://lists.qt-project.org/listinfo/interest

Reply via email to