Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-30076

PostgreSQL driver inserts extra backslashes on PostgreSQL 9.1 and newer

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: P2: Important
    • Resolution: Done
    • Affects Version/s: 4.8.4, 5.0.1
    • Fix Version/s: 4.8.5, 5.1.0 RC1
    • Component/s: SQL Support
    • Labels:
      None
    • Commits:
      e3c5351d06ce8a12f035cd0627356bc64d8c334a 8053ae4030b4342f73a08b9870ccd19189ae401d

      Description

      PostgreSQL driver relies on backslash escaping, inserting backslashes where necessary. Starting with version 9.1, PostgreSQL does NOT threat backslashes as escape characters by default (as mentioned here in a red box), so backslashes are doubled on insertion, but are kept on selection (as expected), so strings with backslashes fail to round-trip through the database.

        Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

            Assignee:
            mabrand Mark Brand
            Reporter:
            blagodarin Sergei Blagodarin
            Votes:
            4 Vote for this issue
            Watchers:
            13 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Gerrit Reviews

                There are no open Gerrit changes