Florian Weimer <fwei...@redhat.com> wrote: > Can you use other JDBC drivers (except SQLite) to insert > Java Strings into NUMERIC columns and Java ints into text > columns?
The JDBC specification can be downloaded from here: http://download.oracle.com/otndocs/jcp/jdbc-4_1-mrel-spec/index.html Check out appendix B. According to the charts there, any of these Java types (from table B-5): String java.math.BigDecimal Boolean Byte Short Integer Long Float Double should be assignable using setObject and setNull to these JDBC target types: TINYINT SMALLINT INTEGER BIGINT REAL FLOAT DOUBLE DECIMAL NUMERIC BIT BOOLEAN CHAR VARCHAR LONGVARCHAR In addition (from the same table) String should be assignable to: BINARY VARBINARY LONGVARBINARY DATE TIME TIMESTAMP So, it's at least partly a question of whether we want to conform to the JDBC specification. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
