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) 
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 
Java Technology 
Copyright © 1993, 2011, Oracle and/or its affiliates. All rights reserved. 