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

Japanese/Chinese characters do not export to Excel correctly

    XMLWordPrintable

Details

    • MOODLE_23_STABLE

    Description

      Files exported from Moodle in .csv format to do not handle UTF8 characters properly. Do this:

      1) Create a new database activity.
      2) Create two fields, "name" and "address"
      3) Copy and paste the following data into two successive records:
      name: 佐藤 宏 address: 〒603 京都市北区上賀茂本山999
      name: 黒田 泰史 address: 〒603 京都市北区上賀茂本山123
      4) Export the data as .csv (I used the tab delimiter)
      5) View the resulting spreadsheet

      This appears to be a problem not only with the database component, but rather with excel export from any Moodle module. See the attached composite screenshot.

      Attachments

        Issue Links

          Activity

            People

              abgreeve Adrian Greeve
              trobb Thomas Robb
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: