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

reworked unicode compatibility check in mysql

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.4
    • Fix Version/s: 2.5
    • Component/s: Database SQL/XMLDB
    • Labels:
    • Testing Instructions:
      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
    • Affected Branches:
      MOODLE_24_STABLE
    • Fixed Branches:
      MOODLE_25_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w51_MDL-37284_m25_mysqlutf8

      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

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  14/May/13