Wrong field type of QSqlField
Unsolved
General and Desktop
-
Hi,
the QSqlField class returns an integer (QVariant::Int) as field type instead of a boolean (QVariant::bool) for a sql server database used with ODBC driver, like mentioned in the docs.SQL Server Management Studio:
QtCreator:
Qt 5.15.2, ODBC Driver 17 for SQL Server
-
The docs do not say that the data type of the QSqlRecord should be QMetaType::Bool - it just tells you that you should use boolean values for it.
But yes, it's a little bit strange, esp. since a bound value of type QMetaType::Bool is send as SQL_BIT. Will take a look on it.
