>I believe there a standard map for JDBC types to Java types. 

I put this together this morning. It is incomplete though.

<!-- java.sql.Types   Java Type            MySQL Type
-->
<!--
-->
<!-- BIT              boolean              BIT
-->
<!-- TINYINT          byte                 TINYINT
-->
<!-- SMALLINT         short                SMALLINT
-->
<!-- INTEGER          int                  INTEGER or INT
-->
<!-- BIGINT           long                 BIGINT
-->
<!-- FLOAT            double               FLOAT
-->
<!-- REAL             ?                    REAL
-->
<!-- DOUBLE           double               DOUBLE
-->
<!-- NUMERIC          ?                    NUMERIC
-->
<!-- DECIMAL          math.BigDecimal      DECIMAL
-->
<!-- CHAR             String               CHAR
-->
<!-- VARCHAR          String               VARCHAR
-->
<!-- LONGVARCHAR      String               TEXT, MEDIUMTEXT, LONGTEXT
-->
<!-- DATE             sql.Date             DATE
-->
<!-- TIME             sql.Time             TIME
-->
<!-- TIMESTAMP        sql.TimeStamp        TIMESTAMP
-->
<!-- BINARY           byte[]               ?
-->
<!-- VARBINARY        byte[]               ?
-->
<!-- LONGVARBINARY    byte[]               ?
-->
<!-- NULL             ?                    ?
-->
<!-- OTHER            Object               ?
-->
<!-- JAVAOBJECT       Object               ?
-->
<!-- DISTINCT         ?                    ?
-->
<!-- STRUCT           ?                    ?
-->
<!-- ARRAY            ?                    ?
-->
<!-- BLOB             ?                    ?
-->
<!-- CLOB             ?                    ?
-->
<!-- REF              ?                    ?
-->



Cameron Riley




------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?:           [EMAIL PROTECTED]

Reply via email to