The utf8mb4 is 100% backwards compatible with utf8 so the answer is yes it is. Thanks for your feedback! 🙂
Hi,
I wich to use charset utf8mb4 and utf8mb4_unicode_ci database collation.
the-utf8mb4-upgrade/
Can I use your plugin for this by replace this in the SQL statements?
Best regards,
Martijn
Sure, but make sure you make a full backup first and use a local DB for changes. Also take a look on http://anothercoffee.net/wordpress-how-to-fix-unknown-collation-error/
Hi,
Thank you very much!!
Shoud I set both constants like below?
define(‘DB_CHARSET’, ‘utf8mb4’);
define(‘DB_COLLATE’, ‘utf8mb4_unicode_ci’);
Best regards,
Martijn
The answer is yes.Thank you for your interest and please let us know how this works.Best regards
-
This reply was modified 7 years, 4 months ago by Presslabs.
-
This reply was modified 7 years, 4 months ago by Presslabs.
Hi,
Thanx again.
Everything is working out fine.
Only tables which are in utf8 and utf8 standard collation, don’t get picked up by the script.
So they don’t get listed in the sql statement as well.
I wish to have everything the same.
Try to replace the plugin php utf8 to utf8mb4 and collation to utf8mb4_unicode_ci
But then I get serveral errors like:
1071. specified key was too long max key length is 767 bytes
Best regards,
Martijn