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

Character Set misreported on shared hosting

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 1.8.2
    • Fix Version/s: 1.6.6, 1.7.4, 1.8.4, 1.9, 2.0
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      MySQL 5.0, PHP 5.1.6, Linux 2.6.22, Apache 1.3.37, HostMonster shared hosting
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE

      Description

      HostMonster's shared hosting MySQL database server does not change the GLOBAL variable for character_set_database relative to the current default database (Moodle's DB), but does change the LOCAL variable.

      grep "SHOW VARIABLES LIKE 'character_set_database'" (should return three locations)

      Change "SHOW VARIABLES" to "SHOW LOCAL VARIABLES"

        Attachments

          Issue Links

          will be (partly) resolved by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-11743 install.php does not recognize UTF8 unicode setup and stops under DB Checker

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

            Activity

              People

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              zannalov Jason Schmidt
              Participants:
              Component watchers:
              Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                11/Jan/08