[solved] MySQL is used as database but does not support 4-byte characters error message persist after fix

Did you also Continue with steps 3 to 5 of the mysql section?

  1. Change your databases character set and collation:
ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  1. Set the mysql.utf8mb4 config to true in your config.php:
sudo -u www-data php occ config:system:set mysql.utf8mb4 --type boolean --value="true"
  1. Convert all existing tables to the new collation by running the repair step:
sudo -u www-data php occ maintenance:repair