User Guide

354 Chapter 2: ColdFusion Tags
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
int
CF_SQL_LONGVARBINARY LONGVARBINARY Long
Varchar for
Bit Data
byte long raw image
CF_SQL_LONGVARCHAR LONGVARCHAR Long
Varchar
text long text, ntext
CF_SQL_MONEY DOUBLE Double
CF_SQL_MONEY4 DOUBLE Double
CF_SQL_NULL NULL
CF_SQL_NUMERIC NUMERIC Numeric 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
ColdFusion JDBC DB2 Informix Oracle MSSQL