Lucee Sql Types

Here are the SQL types supported by Lucee. All are support with and without the CF_SQL_ prefix:

  • 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

See also