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

Add support to case-insensitive searches regardless of the database engine

    XMLWordPrintable

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • Future Dev
    • None
    • Database SQL/XMLDB

    Description

      As described in https://docs.moodle.org/dev/XMLDB_problems#Case-insensitive_searches, some databases engines don't support case-insensitive searches natively.

      It would be great to add support to case-insensitive searches and ordering in core.

      Attachments

        Issue Links

          Discovered while testing

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-63480 Course completion and Activity completion reports fail to filter UTF8 Firstname or Lastname

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-29332 Calculated Questions Require Case Sensitive Data Tables

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed

          Activity

            People

              Unassigned Unassigned
              sarjona Sara Arjona (@sarjona)
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: