On Apr 4, 7:04 pm, "David Crawshaw" <[EMAIL PROTECTED]> wrote: > A simple solution is to switch to using getString("TYPE_NAME"), which > returns whatever name you gave the type when you called CREATE TABLE. > Supporting getInt("DATA_TYPE") is a little more complicated, as SQLite > doesn't actually assign data types to columns. One option would be > parsing the TYPE_NAME (see below), but I'm not too happy about this. I > would prefer to measure the affine type of the column, but this can > only be done by opening up a select statement on the table. Hmm. > > Perhaps I will offer a patch to SQLite to add the affine type to > pragma table_info, that would make it easy. > > For more details on SQLite datatypes:http://sqlite.org/datatype3.html >
snip It's funny, after posting above I downloaded the source and had just finished making almost identical changes to the same file. 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? --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---