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

New Here ,
Mar 09, 2020 Mar 09, 2020

Copy link to clipboard

Copied

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!

Views

31

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation