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?
Aucun commentaire:
Enregistrer un commentaire