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]
-~----------~----~----~----~------~----~------~--~---

Reply via email to