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
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:
can this be merged?
I’ll check, . Stay tuned.