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