Special chars on CSV export

[solracsf]

CSV outputs :

• Mélanie instead of Mélanie
• JoÃl instead of Joël

Etc.

[bpcurse]

I've just tested this by creating a testuser (Database, not LDAP backend) on Nextcloud 20.0.10 / userexport 1.2.1 and did a csv file export using Firefox 89.0/Linux.
After opening the file in LibreOffice (with default UTF-8 setting) "Mélanie Tëst" (Displayname) is displayed correctly 🤔

I have to test this on Nextcloud v21, as soon as I'm able to.

[bpcurse]

Now I was able to test on Nextcloud v21.0.3 but I still cannot recreate the issue.

An experimental user with the displayname "Mélanie Tëst" is displayed correctly in the table, the csv browser display and after opening the csv file with LibreOffice and MousePad.

The only way for me to recreate this issue is by forcing LibreOffice to use another charset on import (like ISO-8859-15/EURO instead of UTF-8). I cannot test this on Windows/Microsoft Office as I got rid of it years ago.

Could this be some individual client/software configuration problem? What software has been used to open the file? Did it ask you for a charset on import? Is the System using UTF-8? Could you try to export and open the csv file on another client system?

[solracsf]

I'll test again soon to be sure.