AnsweredAssumed Answered

ODBC Driver inserts backslash for single quotes

Question asked by MayankSharma on May 7, 2012
Latest reply on Aug 6, 2014 by PH

Summary

ODBC Driver inserts backslash for single quotes

Product

FileMaker Server

Version

11 v3

Operating system version

Microsoft Windows Server 2003 R2

Description of the issue

I am using Microsoft .NET and Filemaker ODBC driver to execute an SQL INSERT statement with parameters. When data has single quotes (apostrophe) in it, ODBC driver replaces ' with \'. This started happening when we updated ODBC driver to version 11.3.81.

Steps to reproduce the problem

Use ODBC Driver version 11.3.81 with .NET to perform an SQL INSERT into a table using parameters. Data should contain apostrophe.
Example Data: John O'Connor

Expected result

John O'Connor

Actual result

John O\'Connor

Workaround

Using non parameterized statements.

Outcomes