Recommended VBSF Types to Database Type Mappings

Recommended VBSF Attribute Types to Database Column Type Mappings

VBSF Type	Oracle 8.1	MS SQL Server 7 SQL Server 2000	Informix 9.2	IBM DB2 5/6	Sybase 11/12	MS Access 2000	Sybase SQL Anywhere 6
BOOLEAN	NUMBER(1,0)	BIT			BIT	Yes/No, BIT	BIT
INTEGER	NUMBER(38,0), INTEGER	INTEGER	INTEGER	INTEGER	INTEGER	Integer, INTEGER	INTEGER
LONG	NUMBER(38,0), INTEGER	BIGINT (SQL 2000), INTEGER (SQL 7)	INT8 (IDS), INTEGER	BIGINT	INTEGER	Long Integer, INTEGER	INTEGER
FLOAT	NUMBER, FLOAT	FLOAT	REAL	REAL, FLOAT(24)	REAL	Single	REAL
DOUBLE	NUMBER, DOUBLE	DOUBLE	DOUBLE	DOUBLE, FLOAT(53)	DOUBLE	Double	FLOAT
STRING	VARCHAR2(n) n <= 4000	VARCHAR(n) n <= 8000	VARCHAR(n) n <= 255	VARCHAR(n) n <= 4000	VARCHAR(n) n <= 255	Text, VARCHAR(n) n <= 255	VARCHAR(n) n <= 32767
DATE	DATE	DATETIME	DATETIME	TIMESTAMP	DATETIME	Date/Time, DATETIME	TIMESTAMP
BIGDECIMAL	NUMBER(38,2), DECIMAL(p,s), NUMERIC(p,s),	MONEY, DECIMAL(p,s), NUMERIC(p,s)	DECIMAL(p,s), NUMERIC(p,s)	DECIMAL(p,s), NUMERIC(p,s)	MONEY, DECIMAL(p,s), NUMERIC(p,s)	Currency	DECIMAL(p,s), NUMERIC(p,s)
BINARY	RAW(n) n <= 2000	VARBINARY(n) n <= 8000	BYTE	VARCHAR(n) FOR BIT DATA n <= 4000	VARBINARY(n) n <= 255	OLE Object, VARBINARY(n) n <= 255	BINARY(n) n <= 32767
MEMO	LONG	TEXT	TEXT	LONG VARCHAR	TEXT	Memo, LONGTEXT	LONG VARCHAR
MEMO - LOB	CLOB		CLOB	CLOB(n)
BLOB	LONG RAW	IMAGE	BYTE	LONGVARCHAR FOR BIT DATA	IMAGE	OLE Object, LONGBINARY	IMAGE
BLOB - LOB	BLOB		BLOB	BLOB(n)
CONTAINED BLOB OBJECT	LONG RAW, RAW(n)	IMAGE, VARBINARY(n)	BYTE	VARCHAR(n) FOR BIT DATA, LONGVARCHAR FOR BIT DATA	IMAGE, VARBINARY(n)	OLE Object, VARBINARY(n) n <= 255	IMAGE, BINARY(n)

Notes:

Blank entries are either types not supported by the database, or types for which there is no recommended database type.
When a VBSF LONG is mapped to a 4 byte INTEGER column data type, precision will be lost for values larger than 32 bits.
For all MEMO and BLOB types VBSF only supports up to 2147483647 (Integer.MAX_VALUE), even if the db supports larger sizes.