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

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

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: Future Dev
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB
    • Labels:

      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

              Assignee:
              Unassigned
              Reporter:
              sarjona Sara Arjona (@sarjona)
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: