search

google-code-export / sqlite4java

Automatically exported from code.google.com/p/sqlite4java
1 stars 1 forks source link

Support for Big Decimal in SQLiteStatement #48

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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?

Original issue reported on code.google.com by jkanthr...@gmail.com on 30 Aug 2012 at 12:40

GoogleCodeExporter commented 9 years ago 
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

Original comment by ser...@gmail.com on 30 Aug 2012 at 3:02

GoogleCodeExporter commented 9 years ago

Original comment by ser...@gmail.com on 14 Aug 2013 at 6:30