utf8mb4 support

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 https://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 8 years ago by Presslabs.
• This reply was modified 8 years 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

Hi Martijn, Maybe this will help you with your problem https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes/1814594#1814594