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

Course Searches are not working for MSSQL databases

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 1.8.3, 1.9
    • 1.8.2
    • 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

      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.

            stronk7 Eloy Lafuente (stronk7)
            jlee@pbu.edu Jay Lee
            Nobody Nobody
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.