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

Problem with firstname, lastname with Umlauten (äöü)

XMLWordPrintable

    • MOODLE_311_STABLE, MOODLE_400_STABLE

      In name lists with alphabets names with German umlaut are not shown correct. The behaviour is different depending which database is used.

      PostgreSQL
      user with first name / lastname with umlaut are not found until we add the umlaut in the alphabet in langconfig file

      Maria DB
      user with first name, last name with umlaut are added to a,o,u. Adding the umlaut in the alphabet the user is found in O and Ö.

      We think this is a bug because it should never be possible that an enrolled user can not be found by this type of filtering. The reason behind are problems with postgreSQL understanding of diacritic signs.
      postgreSQL offers an unaccent functions that may solve this problem but is not used. See https://www.postgresql.org/docs/current/unaccent.html

      It was discussed here https://docs.moodle.org/dev/Database_collation_issue
      and here https://moodle.org/mod/forum/discuss.php?d=427545 and https://tracker.moodle.org/browse/MDL-68274

        1. maria DB.png
          73 kB
          Ralf Hilgenstock
        2. postgre.png
          39 kB
          Ralf Hilgenstock

            Unassigned Unassigned
            ralfh Ralf Hilgenstock
            Votes:
            7 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:

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