Lucee Sql Types
Here are the SQL types supported by Lucee.
All are supported with and without the CF_SQL_ prefix (ACF too since 11):
- CF_SQL_ARRAY / ARRAY
- CF_SQL_BIGINT / BIGINT
- CF_SQL_BINARY / BINARY
- CF_SQL_BIT / BIT
- CF_SQL_BOOLEAN / BOOLEAN
- CF_SQL_BLOB / BLOB
- CF_SQL_CHAR / CHAR
- CF_SQL_CLOB / CLOB
- CF_SQL_DATALINK / DATALINK
- CF_SQL_DATE / DATE
- CF_SQL_DISTINCT / DISTINCT
- CF_SQL_NUMERIC / NUMERIC
- CF_SQL_DECIMAL / DECIMAL
- CF_SQL_DOUBLE / DOUBLE
- CF_SQL_REAL / REAL
- CF_SQL_FLOAT / FLOAT
- CF_SQL_TINYINT / TINYINT
- CF_SQL_SMALLINT / SMALLINT
- CF_SQL_STRUCT / STRUCT
- CF_SQL_INTEGER / INTEGER
- CF_SQL_VARCHAR / VARCHAR
- CF_SQL_NVARCHAR / NVARCHAR
- CF_SQL_VARCHAR2 / VARCHAR2
- CF_SQL_LONGVARBINARY / LONGVARBINARY
- CF_SQL_VARBINARY / VARBINARY
- CF_SQL_LONGVARCHAR / LONGVARCHAR
- CF_SQL_TIME / TIME
- CF_SQL_TIMESTAMP / TIMESTAMP
- CF_SQL_REF / REF
- CF_SQL_REFCURSOR / REFCURSOR
- CF_SQL_OTHER / OTHER
- CF_SQL_NULL / NULL
Since 5.3.6.16
- CF_SQL_NCHAR / NCHAR
- CF_SQL_NVARCHAR / NVARCHAR
- CF_SQL_LONGNVARCHAR / LONGNVARCHAR
- CF_SQL_NCLOB / NCLOB
- CF_SQL_SQLXML / SQLXML
Since 5.3.8.109
- CF_SQL_DATETIME / DATETIME