mbeckler <[EMAIL PROTECTED]> wrote: > One question though, in this patch you have "else if (colType == > "FLOAT"), but from the SQLite datatype page (http://www.sqlite.org/ > datatype3.html) it seems like the proper value there should be REAL?
No, that is why I am unsatisfied with this technique. PRAGMA table_info() does not return the SQLite type affinity (also called a storage class), instead it returns the type given by the user. E.g. sqlite> CREATE TABLE myTable (col1 myBizzareType); sqlite> PRAGMA table_info(myTable); 0|col1|myBizzareType|0||0 This is because SQLite is inherently typeless; it doesn't care what nonsense you make up as a type. What I really want is the storage class, which you can get from sqlite3_column_type(), but only on an open SELECT statement on the table in question. d. --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
