<cfqueryparam> supported CF SQL Data Types missing CF_SQL_NCHAR, CF_SQL_LONGNVARCHAR, CF_SQL_NCLOB and CF_SQL_SQLXML

Description

There is a difference in the supported CF SQL Data Types for <cfqueryparam> between Adobe CF and Lucee.

Adobe CF supports the following additional types added in CF10: CF_SQL_NCHAR, CF_SQL_LONGNVARCHAR, CF_SQL_NCLOB and CF_SQL_SQLXML. See: https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfqueryparam.html

Those types are not listed, and not supported in Lucee. See: https://docs.lucee.org/guides/cookbooks/Sql-Types.html

Assignee

Michael Offner

Reporter

Ben Reid

Labels

Fix versions

Affects versions

Priority

Major
Configure