Migrating Database UTF8 error

[slservice33Participant]

my wordpress database is UTF8 and wp-config says define( ‘DB_CHARSET’, ‘utf8’ );

CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

but when I migrate my site I get the error message

The database server that this WordPress site is running on doesn’t support the character set (utf8) which you are trying to import. You can choose another suitable character set instead and continue with the restoration at your own risk
The database server that this WordPress site is running on doesn’t support the collation (utf8_general_ci) used in the database which you are trying to import. You can choose another suitable collation instead and continue with the restoration (at your own risk).

[slservice33Participant]

This reply has been marked as moderator-only.

[Paul BevanKeymaster]

Hello,

Thank you for your message, regarding these warnings I would recommend selecting utf8mb4 (character set) and utf8mb4_unicode_ci (collation) as compatible and up to date alternatives to allow you to proceed with the restoration.

Best,

Paul

[slservice33Participant]

thanks, I will select utf8mb4_unicode_ci (collation) and worry no more !

[Author]

Posts