Re: QtSql data type mappings
Having the same problem. Is I notice that behavior easy to change with the patch in Qt ODBC driver. So I did :)
P.S. This is my own patch and I think it will never go upstream though.
Re: QtSql data type mappings
This issue popped up again debugging some code and I just noticed the reply as well.
The only update I have is an increased suspicion that the reasoning *may* be a loss-of-precision thing. Despite the IEEE 754 usage, a while back I was having funny behavior with high-precision numbers losing a digit when I did the QString>double conversion. IIRC, this only happened when 1) there were many (16 or 17 I'm guessing?) digits and 2) all digits were in the fractional part (e.g., 0.12435678901234567).
I didn't investigate this very thoroughly because other factors made the issue moot, but perhaps this will help someone (or stoke someone to look into it... maybe I will sometime later).