Usually the charset in the wp-config.php is wrong. Please open your wp-config.php e.g. via FTP and search for:
define( 'DB_CHARSET', 'utf8mb4' );The value of DB_CHARSET should be utf8mb4. Other values are also possible, but if the charset is not utf8XXX and is not listed here https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html, the specification is most likely wrong and the reason why the tables cannot be created.
If in doubt, contact your web hoster and ask them for the correct charset of your MySQL database.