Support for Big Decimal in SQLiteStatement
Issue #48
wontfix
Originally reported on Google Code with ID 48
Big Decimal data type is not supported in SQLITEStatement. Because we are not able to
set and fetch Big Decimal types. Can we add this support to sqlite4Java?
Reported by jkanthraja
on 2012-08-30 12:40:56
Comments (2)
-
-
Reported by
sereda
on 2013-08-14 06:30:06 - Status changed:WontFix
- Log in to comment
``` SQLite does not support arbitrary-length numbers - see http://www.sqlite.org/c3ref/bind_blob.html
Therefore sqlite4java will not support them too. You can convert the value to long or double. If you do have large numbers, you can also convert them to String, but in order to retain correct sort order, you'll need to prefix the string with enough zeroes.
Igor ```
Reported by `sereda` on 2012-08-30 15:02:40 - Labels added: Type-Enhancement - Labels removed: Type-Defect