Lucee Sql Types

Here are the SQL types supported by lucee.

  • CF_SQL_ARRAY
  • CF_SQL_BIGINT
  • CF_SQL_BINARY
  • CF_SQL_BIT
  • CF_SQL_BOOLEAN
  • CF_SQL_BLOB
  • CF_SQL_CHAR
  • CF_SQL_CLOB
  • CF_SQL_DATALINK
  • CF_SQL_DATE
  • CF_SQL_DISTINCT
  • CF_SQL_NUMERIC
  • CF_SQL_DECIMAL
  • CF_SQL_DOUBLE
  • CF_SQL_REAL
  • CF_SQL_FLOAT
  • CF_SQL_TINYINT
  • CF_SQL_SMALLINT
  • CF_SQL_STRUCT
  • CF_SQL_INTEGER
  • CF_SQL_VARCHAR
  • CF_SQL_NVARCHAR
  • CF_SQL_VARCHAR2
  • CF_SQL_LONGVARBINARY
  • CF_SQL_VARBINARY
  • CF_SQL_LONGVARCHAR
  • CF_SQL_TIME
  • CF_SQL_TIMESTAMP
  • CF_SQL_REF
  • CF_SQL_REFCURSOR
  • CF_SQL_OTHER
  • CF_SQL_NULL

See also