Spec-Zone .ru
спецификации, руководства, описания, API
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