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

reworked unicode compatibility check in mysql

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.4
    • 2.5
    • Database SQL/XMLDB
    • MOODLE_24_STABLE
    • MOODLE_25_STABLE
    • w51_MDL-37284_m25_mysqlutf8
    • Hide

      1/ go to Admin / Server / Environment page
      2/ verify unicode is ok
      3/ change default database encoding/collation - the unicode check should be still ok
      4/ change collation and charset of config table - unicode test should fail
      5/ fix config table - unicode should be ok
      6/ set some bogus $CFG->dboptions['dbcollation'] - unicode test should fail again

      7/ do a test install into non-utf8 database
      8/ do any upgrade

      Show
      1/ go to Admin / Server / Environment page 2/ verify unicode is ok 3/ change default database encoding/collation - the unicode check should be still ok 4/ change collation and charset of config table - unicode test should fail 5/ fix config table - unicode should be ok 6/ set some bogus $CFG->dboptions ['dbcollation'] - unicode test should fail again 7/ do a test install into non-utf8 database 8/ do any upgrade

    Description

      Since 2.4 we always specify charset and collation when adding new tables or columns, it means we do not require that the database has utf8 compatible defaults.

      This should prevent all bogus reports about utf8+mysql incompatibility

      Attachments

        Issue Links

          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-12143 Installation Problem with UTF-8

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

          Activity

            People

              skodak Petr Skoda
              skodak Petr Skoda
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Mark Nelson Mark Nelson
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                14/May/13