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

PostgreSQL driver inserts extra backslashes on PostgreSQL 9.1 and newer

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: P2: Important P2: Important
    • 4.8.5, 5.1.0 RC1
    • 4.8.4, 5.0.1
    • SQL Support
    • None
    • e3c5351d06ce8a12f035cd0627356bc64d8c334a 8053ae4030b4342f73a08b9870ccd19189ae401d

      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.

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

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

              Created:
              Updated:
              Resolved:

                There are no open Gerrit changes