Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-7062

Current mssql implementation doesn't support handling of binary (image) fields

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7
    • Fix Version/s: 1.7
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      mssql
    • Affected Branches:
      MOODLE_17_STABLE
    • Fixed Branches:
      MOODLE_17_STABLE

      Description

      While mssql allows direct insert/update of TEXT fields, it seems that binaries aren't allowed.

      So it needs the same type of trick than the used for Oracle (initial insertion to null) and update of image fields later via UpdateBlob().

      So, I'll modify these current methods:

      oracle_detect_lobs()
      oracle_update_lobs()

      to:

      db_detect_lobs()
      oracle_update_lobs()

      allowing them to work, potentially with any DB. Then, conditions in:

      insert_record(), update_record() and set_field() will be changed to call them under mssql too.

        Attachments

          Activity

            People

            Assignee:
            stronk7 Eloy Lafuente (stronk7)
            Reporter:
            stronk7 Eloy Lafuente (stronk7)
            Tester:
            Nobody
            Participants:
            Component watchers:
            Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              7/Nov/06