I'm using Moodle 3.10 and have a problem on the participants list in the course. When I click in the filters to select users by first name, for example, the list doesn't show names with accent on the first letter. How can I fix this?
My database type is PostgreSQL, encoding UTF-8.
First example, all the students in the list:
Second, with the letter A selected:
I can reproduce this problem with PostgreSQL but not MySQL/MariaDB. Presumably the issue is that Moodle depends on the database's character collation to match 'A' and 'Á' and the databases behave differently.
I think this problem is described in MDL-68274. The proposed workaround of changing $string['alphabet'] doesn't seem workable if the translation maintainers won't accept this change (for good reasons).
For the workaround the only change is to langconfig.php for whichever language packs are installed, possibly lang/en/langconfig.php and moodledata/lang/pt_br/langconfig.php. Add the accented letters to:
$string['alphabet'] = 'A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z';
You'll probably need to purge caches after making these changes so that they take effect.
There's no change needed in the database.
Perfect! Thanks a lot for your help!