SQLite only has a few data types: NULL, INTEGER, REAL, TEXT, BLOB
Meanwhile, the JDBC has:
-7 BIT,
-6 TINYINT,
-5 BIGINT,
-4 LONGVARBINARY,
-3 VARBINARY,
-2 BINARY,
-1 LONGVARCHAR,
0 NULL,
1 CHAR,
2 NUMERIC,
3 DECIMAL,
4 INTEGER,
5 SMALLINT,
6 FLOAT,
7 REAL,
8 DOUBLE,
12 VARCHAR,
91 DATE,
92 TIME,
93 TIMESTAMP,
1111 OTHER.
(possibly more)
I can't find any documentation anywhere for the SQLite-specific JDBC driver, and I need to know how the driver maps the types.
Obviously null is null,
integer is integer (probably),
real is real (probably),
but what do text and blob map to?