8 Replies Latest reply on Aug 6, 2014 10:29 PM by PH

    ODBC Driver inserts backslash for single quotes

    MayankSharma

      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.