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

              Assignee:
              skodak Petr Skoda
              Reporter:
              skodak Petr Skoda
              Integrator:
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Tester:
              Mark Nelson Mark Nelson
              Participants:
              Component watchers:
              Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

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