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

Problem with CLOBS and Qt OCI database driver

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • P3: Somewhat important
    • 4.6.1
    • 4.5.1
    • SQL Support
    • None
    • 65fe21e8c1cfb70e5b763818928c6570bb67b5e3

    Description

      It seems that the Qt OCI database driver can't write properly data into a sql field in the database of type CLOB. The problem seems to be caused by the mapping between OCI data types and Qt data types. The mapping from sql data types to QVariant values (reading from database) is right. The CLOB data type and the BLOB data type will be mapped to the QByteArray data type, but the mapping from QVariant values to the sql data types (writing to database) is the problem: The QByteArray will only be mapped to the BLOB data type but NOT to the CLOB data type. This results in a binary representation of the character string like "54657374" in the database AND the model (and the gui).

      Attachments

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

        Activity

          People

            bilking Bill King
            sanonymous Nokia Qt Support (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes