dimanche 24 avril 2016

How do SQLite data types map to Java?

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