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

reworked unicode compatibility check in mysql

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.5
    • 2.4
    • 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

      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

            skodak Petr Skoda (Inactive)
            skodak Petr Skoda (Inactive)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Mark Nelson Mark Nelson
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

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