Database Results Trim (CHAR) in Coldfusion 2018 -Dcoldfusion.trim.dbresult=true

Report · Mar 09, 2020

Hi,

I recently upgraded a CF10 Server to CF2018. In ColdFusion 10, ODBC queries to DB2 (CHAR) fields returned trimmed values. Now in CF2018 it returns the full char length and many comparisons to other tables in MySQL or SQL are returning empty. I was able to fix some by adding SELECT trim(fieldname)... But the server host many applications with thousands of .cfm pages; so it will be a dauting task to fix all those queries. I found a JVM argumment setting of "-Dcoldfusion.trim.dbresult=true" listed for CF11; but it does not apperas to be working in CF2018.

Any idea if this can be enabled in a DSN or any other CF setting?

Thanks!