SAP Knowledge Base Article - Preview

3828131 - Double quotes removed when inserting string values via JDBC adapter into EXT table in SAP Integration Suite

Symptom

  • When posting string values containing double quotes into an EXT table using the JDBC adapter, the quotes are not preserved in the target.
  • Target column is STRING/VARCHAR; a source value like "MR" is persisted as MR in the target.
  • No error messages are displayed.


Read more...

Environment

SAP Integration Suite

Product

SAP Integration Suite all versions

Keywords

jdbc adapter, double quotes, quotes removed, string literal, varchar, ext table, insert values, sql escaping, prepared statement, parameterized sql, special characters, jdbc write, mapping, data preservation, sql dialect , KBA , LOD-HCI-PI-MAP , Integration Mapping Service , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.