| Documentation Contents

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

Copyright © 1995-2010 Sun Microsystems, Inc. All Rights Reserved. Please send comments using this Feedback page. | Java Technology