Hello,
NC-18.0.6 is running with PHP-7.2 and MySQL-5.7.
PHPMyAdmin shows me utf8mb4_unicode_ci with utf8mb4_bin for all tables, occ maintenance:repair shows no errors.
I have the exactly the same problem and almost the same software versions.
Followed the steps from Nextcloud docs to enable utf8mb4 support, but the collation was changed to “utf8mb4_bin” instead of the recommended “utf8mb4_general_ci”.
I’m somewhat confused what I should do about this. I could switch all tables manually to “utf8mb4_general_ci”, but I’m not sure if that might break something.
The Nextcloud docs might not be up to date on this matter.
I changed the collation manually for the tables in phpMyAdmin and ran the occ repair pricess after that. The repair command changed all tables back to “utf8mb4_bin” collation.
Therefore I assume/hope that it’s the right and currently supported collation for utfmb4.