http://java.sun.com/products//jdk/1.2/docs/guide/jdbc/getstart/mapping.doc.h
tml
 scroll down to the bottom to see all the summarized tables

> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Riley, Cameron
> Sent: Wednesday, November 22, 2000 10:28 AM
> To: 'Turbine'
> Subject: RE: Torque types
>
>
>
> >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]
>
>



------------------------------------------------------------
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