preferred MySQL/mariaDB collation

Open hex-m opened this issue 6 years ago • 3 comments

The documentation suggests to use "utf8mb4_general_ci" in your Nextcloud DB.

I'm not super knowledgeable about this but my research told me that utf8mb4_unicode_ci would be the more "correct" choice.

Are there specific reasons why Nextcloud suggests "utf8mb4_general_ci" or should this be changed?

Jul 22 '19 14:07 hex-m

cc @nickvergessen

Jul 22 '19 15:07 MorrisJobke

That's also used in our source code, so we should adjust it there first, the question is, if that even works, or if it causes a problem when the collation is tried to be migrated.

Jul 23 '19 07:07 nickvergessen

so move it to github.com/nextcloud/server/issues?

Apr 22 '22 16:04 tflidd