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

Course Searches are not working for MSSQL databases

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.8.2
    • 1.8.3, 1.9
    • Course
    • None
    • RHEL5 x86_64, PHP 5.1.6, Apache 2.2.3
      Windows Server 2003 SP2 x64 Edition, Microsoft SQL Server 2005 w/ SP2
    • Microsoft SQL
    • MOODLE_18_STABLE
    • MOODLE_18_STABLE, MOODLE_19_STABLE

    Description

      Course searches do not work in Moodle 1.8 with MSSQL as the backend. This is because ADODB will prepend an 'N' to quoted literal strings when appropriate to indicate unicode strings. If no space is left between operators such as LIKE, NOT, etc, the 'N' is placed right up against the operator with no white space.

      A simple change to lines 923 and 924 in lib/datalib.php of adding a space before the quoted literal string allows the 'N' that adodb prepends to be properly handled while performing a search.

      Attachments

        Activity

          People

            stronk7 Eloy Lafuente (stronk7)
            jlee@pbu.edu Jay Lee
            Nobody Nobody
            Amaia Anabitarte, Carlos Escobedo, Laurent David, Sabina Abellan, Sara Arjona (@sarjona)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              11/Oct/07