On Monday, 28 November 2022 12:07:22 PST Scott Bloom wrote: > but if they did a create XXX as string, insert XXX=123 (integer) and Sqlite > can return it as a string or an integer, the QVariant should be created > from an string not an integer. The same goes if they did a create XXX as > integer, insert XXX='123'. QVariant should be created as from an integer > type, and they can do a toString on the variant if they want. > > My point, dynamic types should follow C++ style "dynamic" typing not > "everything is a string until proven otherwise" typing of other languages.
I don't agree. Sqlite seems to have made a choice that the type is stored per row, but gives you the ability to choose otherwise either at table creation time or at selection time. Changing the behaviour right now would remove that possibility. I don't know if it is surprising or not for unwary people. But I can tell you that no action will happen because QtSql is right now under-maintained and there are no volunteers to understand all the implications of such a choice. -- 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