JDBC Type Name
Oracle 8.1 Sybase 11.9 Informix 9.2 IBM DB2 5.2 (Unix, NT) Microsoft SQL Server 7.0 Microsoft Access 7.0 Sybase SQL Anywhere 6.0
BIT
  BIT     BIT BIT BIT
TINYINT
  TINYINT SMALLINT   TINYINT BYTE TINYINT
SMALLINT
SMALLINT, NUMBER(38,0) SMALLINT SMALLINT SMALLINT SMALLINT SMALLINT SMALLINT
INTEGER
INTEGER, NUMBER(38,0) INTEGER INTEGER, SERIAL INTEGER INTEGER INTEGER, COUNTER INTEGER
BIGINT
    INT8, SERIAL8 BIGINT      
REAL
REAL, NUMBER REAL REAL REAL REAL REAL REAL
FLOAT
FLOAT, NUMBER FLOAT FLOAT FLOAT FLOAT   FLOAT
DOUBLE
DOUBLE PRECISION, NUMBER DOUBLE PRECISION DOUBLE PRECISION FLOAT DOUBLE PRECISION DOUBLE DOUBLE PRECISION
NUMERIC(p,s)
NUMERIC(p,s), NUMBER(p,s) NUMERIC(p,s) NUMERIC(p,s) NUMERIC(p,s) NUMERIC(p,s) CURRENCY NUMERIC(p,s)
DECIMAL(p,s)
DECIMAL(p,s), NUMBER(p,s) DECIMAL(p,s), MONEY DECIMAL(p,s) DECIMAL(p,s) DECIMAL(p,s), MONEY   DECIMAL(p,s)
CHAR(n)

CHAR(n)
n <= 2000

CHAR(n)
n <= 255
CHAR(n)
n <= 32767
CHAR(n)
n <= 254
CHAR(n)
n <= 8000
CHAR(n)
n <= 255
CHAR(n)
n <= 32,767
VARCHAR(n)
VARCHAR(n)
n <= 4000
VARCHAR(n)
n <= 255
VARCHAR(n)
n <= 255
VARCHAR(n)
n <= 4000
VARCHAR(n)
n <= 8000
VARCHAR(n)
n <= 255
VARCHAR(n)
n <= 32,767
LONGVARCHAR
LONG
limit is 2 Gigabytes
TEXT
limit is 2 Gigabytes
TEXT
limit is 2 Gigabytes
LONG VARCHAR
limit is 32,700 bytes
TEXT
limit is 2 Gigabytes
LONGCHAR
limit is 2.0 Gigabytes
LONG VARCHAR
limit is 2 Gigabytes
BINARY(n)
  BINARY(n)
n <= 255
BYTE CHAR(n) FOR BIT DATA
n <= 254
BINARY(n)
n <= 8000
BINARY(n)
n <= 255
BINARY
n <= 32,767
VARBINARY
RAW(n)
n <= 2000
VARBINARY(n)
n <= 255
BYTE VARCHAR(n) FOR BIT DATA
n <= 4000
VARBINARY(n)
n <= 8000
VARBINARY(n)
n <= 255
 
LONGVARBINARY
LONG RAW
limit is 2 Gigabyts
IMAGE
limit is 2 Gigabytes
BYTE
limit is 2 Gigabytes
LONG VARCHAR FOR BIT DATA
limit is 32,700 bytes
IMAGE
limit is 2 Gigabytes
LONGBINARY
limit is 1.0 Gigabytes
IMAGE
limit is 2 Gigabytes
DATE
    DATE DATE     DATE
TIME
    DATETIME HOUR TO SECOND TIME     TIME
TIMESTAMP
DATE DATETIME, SMALLDATETIME DATETIME YEAR TO FRACTION(S) TIMESTAMP DATETIME DATETIME TIMESTAMP
CLOB
CLOB   CLOB CLOB(n)
n <= 2,147,483,647 bytes
     
BLOB
BLOB, BFILE   BLOB BLOB(n)
n <= 15,000,000 bytes
     
ARRAY
VARRAY   LIST, SET, MULTISET        
STRUCT
OBJECT   ROW        
DISTINCT
    DISTINCT        
REF
REF            
JAVA_OBJECT
    OPAQUE        

Oracle and/or its affiliates
Java Technology

Copyright © 1993, 2011, Oracle and/or its affiliates. All rights reserved.

Contact Us