<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

Activity

Show:
Pothys - MitrahSoft
July 11, 2019, 12:05 PM

I've checked this ticket & confirmed some of the SQL data types are not supported in lucee as per your description. I have added CFSQL types, which can be supported in ACF.
Also, I updated a CFSQL supported data types in lucee docs. Here below I listed out the newly added data types for SQL,

Added data types:

CF_SQL_NCHAR
CF_SQL_NVARCHAR
CF_SQL_LONGNVARCHAR
CF_SQL_NCLOB
CF_SQL_SQLXML

Pull request:

For Lucee: https://github.com/lucee/Lucee/pull/721
For Lucee_Docs: https://github.com/lucee/lucee-docs/pull/657

Ben Reid
July 11, 2019, 11:43 PM

Thank you.

Zac Spitzer
March 3, 2020, 4:44 PM

can this be merged?

Patrick Quinn
March 3, 2020, 7:43 PM

I’ll check, . Stay tuned.

Zac Spitzer
March 13, 2020, 12:56 PM

docs updated, noting which version these were added in

https://docs.lucee.org/guides/cookbooks/Sql-Types.html

Fixed

Assignee

Michael Offner

Reporter

Ben Reid

Labels

Fix versions

Affects versions

Priority

Major
Configure