System.Data.SQLite

It turnes out that real number values using the C# type "Double" are correctly supported and mapped if its value is inside the range "Single.MinValue" to "Single.MinValue". But the desired range of "Double.MinValue" to "Double.MinValue" is not driven correctly. The values occur as infinite.

My same library detects proper work with the "Devart SQLite Provider docConnect" which lets me follow that "System.Data.SQLite.dll" and/or "SQLite.Interop.dll" limits the real value range in the "Single"-type area instead of the "Double"-type area even though SQLite itself can do real values with the huge range. It is at least an issue of reading the DB. May be of writing also.

The problem is important for applications dealing with Currency values mapped to C# Double type where Single does not support a sufficient mantissa.

By the way: C# "Decimal" type is not feasible with native SQLlite so this support is not feasible and no substitution.

Kind regards efef

anonymous added on 2011-05-25 07:46:24 UTC:
no subject since System.Data.Sqlite supports DOUBLE and REAL appropriate

anonymous added on 2011-05-29 08:08:51 UTC:
When you declare a table column as NUMERIC, DECIMAL, MONEY or CURRENCY, System.Data.SQLite maps that column as DbType.Decimal. http://sqlite.phxsoftware.com/forums/t/31.aspx. Furthermore, there is no precission loss, since the data is stored as a string from version 1.0.56.0 - August 11, 2008 http://sqlite.phxsoftware.com/readme.htm

mistachkin added on 2011-07-05 07:50:13 UTC:
Fixed by [eb6a22a1a9]. For tests, see [2a2aa7392c].