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

Blob escape in postgresql (qpsql) driver

    XMLWordPrintable

Details

    • Bug
    • Resolution: Out of scope
    • P3: Somewhat important
    • Some future release
    • 4.6.3
    • SQL Support
    • None
    • PostgreSQL 8.3+ (But as i read it, it's an issue with 8.2 too)
      Debian 5 64-bit

    Description

      Insert of blob (bytea) into postgresql results in:

      WARNING:  nonstandard use of \\ in a string literal
      

      Where \ \ could be a number of different escape-sequences.

      Apparently the correct way to escape this is: "E'\ \....'::bytea" according to http://www.postgresql.org/docs/8.2/static/datatype-binary.html

      Patch supplied

      Attachments

        For Gerrit Dashboard: QTBUG-11459
        # Subject Branch Project Status CR V

        Activity

          People

            andysh Andy Shaw
            mb@dbc.dk Morten Bogeskov
            Votes:
            5 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes