What is the Nextcloud proper way to convert the database from utf8_bin to utf8_mb4?

Hi
The current Nextcloud database is set to utf8_bin. It seems like I should update to mb4. I am not a techy person so I used Phpmyadmin to convert to mb4 using the operations tab. It seemed like everything worked except when I searched. It started throwing errors (those pop ups errors in the UI) complaining that it cant search in bunch of apps.

That scared me a bit so I reverted back to the backup. Given I need to do the conversion, what is the proper way to do this so that it all works? Maybe I had to do some other stuff after the initial conversion, but I was not sure about the steps.

thanks

https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/mysql_4byte_support.html

1 Like