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

Case-insensitive collations in the database cause problems and should be changed to case-sensitive

    XMLWordPrintable

Details

    • MOODLE_23_STABLE

    Description

      The problem, and a proposed solution, are described at http://docs.moodle.org/dev/Database_collation_issue.

      Attachments

        Issue Links

          has a non-specific relationship to

          Sub-task - Issues are sometimes broken into multiple sub-tasks. MDL-34271 improve mysql collation handling

          • Major - Major loss of function, incorrect output
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-22117 Units in numerical questions are acting case sensitive, but not functioning that way.

          • Major - Major loss of function, incorrect output
          • Reopened

          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

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-30446 Glossary order issues for some collation settings

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-33655 MySQL case insensitivity breaks get_directory_files

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-67315 Custom profile field : uppercase letter in short name blocks the notification page

          • Minor - Minor loss of function where workaround is possible
          • Open

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-47617 user/tests/behat/table_sorting.feature is failing

          • Minor - Minor loss of function where workaround is possible
          • Closed

          New Feature - A new Moodle feature which has yet to be developed. MDL-46269 Convert http embedded content to https on https sites where available

          • Major - Major loss of function, incorrect output
          • Closed

          Improvement - An enhancement to an existing Moodle feature. MDL-73461 Make custom user profile field shortnames case-insensitive

          • Minor - Minor loss of function where workaround is possible
          • Open
          is duplicated by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-70764 unicode mapping collision with unicode_ci collation in numerical question fails with "error writing to database"

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDL-55537 POLICY: Change recommended MySQL collation to case-sensitive

          • Minor - Minor loss of function where workaround is possible
          • Closed
          will be (partly) resolved by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-71643 dmlwriteexeption error when importing quiz questions (tag related)

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              moodle.com Moodle HQ
              timhunt Tim Hunt
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              15 Vote for this issue
              Watchers:
              17 Start watching this issue

              Dates

                Created:
                Updated: