I would like to convert a MySQL database, which has
utf8mb4 character set and
How to do that please?
Thank you in advance for your suggestions.
I just solved the charset problem by using Notepad++.
The problem was that my php version is 126.96.36.199 and the hosting firm's was 3.3.8. Because of that, it could not work with the
To solve the problem open the exported SQL file, search and replace the
utf8, after that search and replace the
utf8_general_ci. Save the file and import it into your database. After that, change the wp-config.php charset option to
utf8, and the magic starts.
Note that it worked in a Hungarian database.
Run in PhpMyAdmin:
ALTER DATABASE yourdatabasename CHARACTER SET utf8 COLLATE utf8_unicode_ci