tracker issue : CF-4204181

select a category, or use search below
(searches all categories and all time range)
Title:

When editing a datasource in the CF administrator the JDBC connection string changes causing data corruption

| View in Tracker

Status/Resolution/Reason: To Track//PRNeedInfo

Reporter/Name(from Bugbase): Gareth E. / ()

Created: 04/16/2019

Components: Database, JDBC

Versions: 2018

Failure Type: Data Corruption

Found In Build/Fixed In Build: 2018.0.02.313961 /

Priority/Frequency: Normal / Most users will encounter

Locale/System: English / Windows 10

Vote Count: 0

Problem Description:
When editing settings in a MSSQL datasource in the CF administrator the JDBC connection string defined in the neo-datasource.xml changes from sendStringParametersAsUnicode=false to sendStringParametersAsUnicode=no, data corruption occurs when reading and writing varbinary columns in a MSSQL database with the COLLATION "Latin1_General_CI_AS"

Steps to Reproduce:
Edit a datasource in the ColdFusion administrator, neo-datasource.xml changes from sendStringParametersAsUnicode=false to sendStringParametersAsUnicode=no

Actual Result:
JDBC connection string defined in the neo-datasource.xml changes from sendStringParametersAsUnicode=false to sendStringParametersAsUnicode=no, data corruption occurs when reading and writing varbinary columns in a MSSQL database with the COLLATION "Latin1_General_CI_AS"

Expected Result:
sendStringParametersAsUnicode should stay as sendStringParametersAsUnicode=false

Any Workarounds:
Delete datasource and recreate it

Attachments:

Comments:

@Gareth We were able to repro this issue on CF2018Update2.  Please try applying the latest update  i.e CF2018Update3, should solve this issue. Please check and let us know if you still face this issue.
Comment by Dattanand M.
30715 | May 13, 2019 08:08:45 AM GMT