ColdFusion CFQUERYPARAM Types

ColdFusion	JDBC	DB2	Informix	Oracle	MS Access	MSSQL
CF_SQL_ARRAY	ARRAY
CF_SQL_BIGINT	BIGINT	Bigint	int8, serial8		Yes/No
CF_SQL_BINARY	BINARY	Char for Bit Data				binary timestamp
CF_SQL_BIT	BIT		boolean			bit
CF_SQL_BLOB	BLOB	Blob	blob	blob, bfile
CF_SQL_CHAR	CHAR	Char	char, nchar	char, nchar		char, nchar, unique identifier
CF_SQL_CLOB	CLOB	Clob	clob	clob,nclob
CF_SQL_DATE	DATE	Date	date, datetime, year to day
CF_SQL_DECIMAL	DECIMAL	Decimal	decimal, money	number		decimal, money, small money
CF_SQL_DISTINCT	DISTINCT
CF_SQL_DOUBLE	DOUBLE	Double
CF_SQL_FLOAT	FLOAT	Float	float	number		float
CF_SQL_IDSTAMP	CHAR	Char	char, nchar	char, nchar		char, nchar, unique identifier
CF_SQL_INTEGER	INTEGER	Integer	integer, serial		AutoNumber	int
CF_SQL_LONGVARBINARY	LONGVARBINARY	Long Varchar for Bit Data	byte	long raw		image
CF_SQL_LONGVARCHAR	LONGVARCHAR	Long Varchar	text	long	Memo	text, ntext
CF_SQL_MONEY	DOUBLE	Double			Currency
CF_SQL_MONEY4	DOUBLE	Double
CF_SQL_NULL	NULL
CF_SQL_NUMERIC	NUMERIC	Numeric			Number	numeric
CF_SQL_OTHER	OTHER
CF_SQL_REAL	REAL	Real	smallfloat			real
CF_SQL_REFCURSOR	REF
CF_SQL_SMALLINT	SMALLINT	Smallint	smallint			smallint
CF_SQL_STRUCT	STRUCT
CF_SQL_TIME	TIME	Time	datetime hour to second
CF_SQL_TIMESTAMP	TIMESTAMP	Timestamp	datetime year to fraction(5), datetime year to second	date	Date/Time	datetime, smalldate time
CF_SQL_TINYINT	TINYINT					tinyint
CF_SQL_VARBINARY	VARBINARY	Rowid		raw		varbinary
CF_SQL_VARCHAR	VARCHAR	Varchar	varchar, nvarchar, lvarchar	varchar2, nvarchar2	Text	varchar, nvarchar, sysname