Problems with sqlite data types

[Boyd Kelly]

Hello,

I realize that sqlite is 'flexible' with data types. My sqlite
schema is currently has several columns with "Price" DECIMAL(10,3),
butI have also tried to change to NUMERIC etc.

However when I use jdbc to connect via Birt or Crystal Reports, it
picks up all the numeric fields as strings. Is there some kind of
options that I can use with jdbc to force it to recognize those fields
as numeric?

Regards,

Boyd

[Grace B]

On Friday, February 17, 2012 3:41:54 PM UTC-5, Boyd Kelly wrote:

However when I use jdbc to connect via Birt or Crystal Reports, it
picks up all the numeric fields as strings.  Is there some kind of
options that I can use with jdbc to force it to recognize those fields
as numeric? 

This issue was fixed. Checkout https://bitbucket.org/xerial/sqlite-jdbc/issue/43