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