NC-18.0.6: utf8mb4_unicode_ci with utf8mb4_bin

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.

In Enabling MySQL 4-byte support COLLATE utf8mb4_general_ci is mentioned as collation.

So what is the difference between utf8mb4_general_ci and utf8mb4_unicode_ci?

Change to utf8mb4_general_ci needed?
Can it be done by switching setting in PHPMyAdmin only?

Thx and best regards!



Really no hint about this question?

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.

Please refer to:

Question relays to collation of MySQL-connection, not only the utf8mb4_bin collation of the tables.

Is there any need for switching from
utf8mb4_unicode_ci to utf8mb4_general_ci ?

Thanks and best regards.