Hi, Recently, I've started using the jdbc driver and I've noticed something bizarre to me: the types given by getColumnType are not returning what I expected.
For example, if I declare a table like: CREATE TABLE TESTTABLE( col1 DOUBLE ); insert some data and do: SELECT * FROM TESTTABLE The getColumnType from ResultSetMetaData tells me that column 1 of that query is a float. According to the documentation @ http://www.sqlite.org/datatype3.html, all reals are stored as 8-byte floating point numbers, also known as doubles. In the end, this simply means that getColumnType is not trustworthy and using it to drive casting may result in lost data. (the same goes for ints and longs) Are there any plans to change this in the future? Or is this a design choice and here to stay? Sincerely, Sergio. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLiteJDBC" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlitejdbc?hl=en -~----------~----~----~----~------~----~------~--~---
