Support for Big Decimal in SQLiteStatement

Issue #48 wontfix
Former user created an issue

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)

  1. Igor Sereda

    ``` 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

  2. Log in to comment